Assuming you have the worksheet set up with headings in row 1, data
validation in column A, and dependent data validation in columns B and D:

Enter a dummy record in row 2.
In A3, enter: =IF(A2="","",A2)
In B3, enter: =IF(B2="","",IF(A3<A2,"",B2))
Copy those formulas down to the last row for data entry.

Clear the dummy record.
Save that as your master copy

When the employee selects values in row 2, they'll fill down the sheet
If they select a different client further down the list, it will
overwrite the formula in column A, and the adjacent cell in column B
will show as blank, so they can select a Team.


CloudDoctor wrote:
Hi Everyone,

I'm currenlty creating a timesheet with 4 columns of data. Col A will
hold the Client, Col B the Team (Accounts / Marketing / Events), Col C
will be a 4 digit project number (entered manually) and Col D is the
Job code (Visit / Development / Invoice etc).

I need employees to be able to choose a client from the drop down in
A, which will then determine which list of teams they see in B. Then
make a choice in B which determines the list of jobs shown in column
D.

Employees need to account for every six minutes (!!) of their time to
allow for cross and back charging (accountants dream!).

I was able to use previous posts and Debra Dalgleish's examples to
achieve the dependent list - thanks.

The issue I'm now facing is that, so I don't annoy the employees, I
need to be able to autofill the rest of the rows (85 a day) with their
initial choice until such a time when they change clients/jobs and
make a new choice from the drop down lists. I tried adding =A3 into
A4 but the data validation wouldn't work as I think (have got brain
melt at the moment) the data validation in Debra's example
[ =IF(B3="",BusCodeList,B3) ] relies on the cells in the row being
empty...

Has anyone got any ideas? If possible I'd like to be able to achieve
this without coding.

Thanks for your time/help,

Dani



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html