software

I am an Excel novice so please be patient!
My problem is this-
I have a drop down list set up in D2 in worksheet 1 which references a list
of customers contained in column A in worksheet 2. When the selection is made
in D1, sheet 1 it returns a contract number in E2 from column B in sheet 2
using VLOOKUP funtion (and so on down the sheet). As the enteries in sheet 2
Col A are not a definitive list of possible customers, nor are the contract
number in Col B a definitive list of job numbers that may be associated with
a particular customer, the user can enter their own values into Sheet 1, D2
and E2.
Pretty staight forward so far!
What I would like to happen would be 1 of 2 possibilities
1- If the user enters a customers name and job number that does not appear
in sheet 2 col A and B, the entries will be added to the relavant columns for
selection in the future.
2- If the user enters a customers name that does exist in Col A sheet 2, but
ammends the job number (we use 1 type of job number for a contract and
another for one off specific jobs) that number is some how added to a list of
job numbers for that customer and when that customer is select in the future,
further down the sheet, all associated numbers appear in another drop down
list.
A solution to 1 would be great, but a solution to 2 would be superb( I
appreciate it may be way out of my depth) and score me loads of points with
the boss.
I've noticed, whilst trawling through loads of postings seraching for an
answer, that people have posted specific solution based on the posteractual
worksheet, so if any one kind enough to profer any solutions needs more info
I will do my best to come up with the goods.

This will require VBA programming. If you don't get any replies after a day
or so repost in the programming forum.

Biff

quot;Mark Dullinghamquot; lt;Mark gt; wrote in
message ...
gt;I am an Excel novice so please be patient!
gt; My problem is this-
gt; I have a drop down list set up in D2 in worksheet 1 which references a
gt; list
gt; of customers contained in column A in worksheet 2. When the selection is
gt; made
gt; in D1, sheet 1 it returns a contract number in E2 from column B in sheet 2
gt; using VLOOKUP funtion (and so on down the sheet). As the enteries in sheet
gt; 2
gt; Col A are not a definitive list of possible customers, nor are the
gt; contract
gt; number in Col B a definitive list of job numbers that may be associated
gt; with
gt; a particular customer, the user can enter their own values into Sheet 1,
gt; D2
gt; and E2.
gt; Pretty staight forward so far!
gt; What I would like to happen would be 1 of 2 possibilities
gt; 1- If the user enters a customers name and job number that does not appear
gt; in sheet 2 col A and B, the entries will be added to the relavant columns
gt; for
gt; selection in the future.
gt; 2- If the user enters a customers name that does exist in Col A sheet 2,
gt; but
gt; ammends the job number (we use 1 type of job number for a contract and
gt; another for one off specific jobs) that number is some how added to a list
gt; of
gt; job numbers for that customer and when that customer is select in the
gt; future,
gt; further down the sheet, all associated numbers appear in another drop down
gt; list.
gt; A solution to 1 would be great, but a solution to 2 would be superb( I
gt; appreciate it may be way out of my depth) and score me loads of points
gt; with
gt; the boss.
gt; I've noticed, whilst trawling through loads of postings seraching for an
gt; answer, that people have posted specific solution based on the
gt; posteractual
gt; worksheet, so if any one kind enough to profer any solutions needs more
gt; info
gt; I will do my best to come up with the goods.
Will do.
Thanks Biff

quot;Biffquot; wrote:

gt; This will require VBA programming. If you don't get any replies after a day
gt; or so repost in the programming forum.
gt;
gt; Biff
gt;
gt; quot;Mark Dullinghamquot; lt;Mark gt; wrote in
gt; message ...
gt; gt;I am an Excel novice so please be patient!
gt; gt; My problem is this-
gt; gt; I have a drop down list set up in D2 in worksheet 1 which references a
gt; gt; list
gt; gt; of customers contained in column A in worksheet 2. When the selection is
gt; gt; made
gt; gt; in D1, sheet 1 it returns a contract number in E2 from column B in sheet 2
gt; gt; using VLOOKUP funtion (and so on down the sheet). As the enteries in sheet
gt; gt; 2
gt; gt; Col A are not a definitive list of possible customers, nor are the
gt; gt; contract
gt; gt; number in Col B a definitive list of job numbers that may be associated
gt; gt; with
gt; gt; a particular customer, the user can enter their own values into Sheet 1,
gt; gt; D2
gt; gt; and E2.
gt; gt; Pretty staight forward so far!
gt; gt; What I would like to happen would be 1 of 2 possibilities
gt; gt; 1- If the user enters a customers name and job number that does not appear
gt; gt; in sheet 2 col A and B, the entries will be added to the relavant columns
gt; gt; for
gt; gt; selection in the future.
gt; gt; 2- If the user enters a customers name that does exist in Col A sheet 2,
gt; gt; but
gt; gt; ammends the job number (we use 1 type of job number for a contract and
gt; gt; another for one off specific jobs) that number is some how added to a list
gt; gt; of
gt; gt; job numbers for that customer and when that customer is select in the
gt; gt; future,
gt; gt; further down the sheet, all associated numbers appear in another drop down
gt; gt; list.
gt; gt; A solution to 1 would be great, but a solution to 2 would be superb( I
gt; gt; appreciate it may be way out of my depth) and score me loads of points
gt; gt; with
gt; gt; the boss.
gt; gt; I've noticed, whilst trawling through loads of postings seraching for an
gt; gt; answer, that people have posted specific solution based on the
gt; gt; posteractual
gt; gt; worksheet, so if any one kind enough to profer any solutions needs more
gt; gt; info
gt; gt; I will do my best to come up with the goods.
gt;
gt;
gt;