Dependent Lists & Timesheets...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

.

Relevant Pages

  • Re: Spam Filter
    ... accounts and we surveyed our clientele ... Those employees who have this active on their accounts (not everyone ... >email from the user requesting confirmation the it sent the email. ... >s/he can't create an account or join my lists I will tell them (and reply to ...
    (RedHat)
  • Re: Shared Contacts
    ... I will soon be setting up a server for a client who currently have 6 employees with 6 separate 'Contacts' lists. ...
    (microsoft.public.windows.server.sbs)
  • 40iPlay C/S audio player/recorder
    ... iPlay also works fine for CDs, ... Order of the main list can be by: load order (e.g., playlists load in ... long lists (iPlay Client handles up to 40,000 files -- a size which can ...
    (microsoft.public.pocketpc.multimedia)
  • Re: E-mail filtering recommendations needed.
    ... company's server and send outgoing e-mail through the same server. ... You could put up a local mail server which will poll the ISPs ... Then the user pop accounts would be removed from ... SS numbers and protected client information? ...
    (comp.unix.sco.misc)
  • Re: Cannot login to retrieve internet mail
    ... You are correct in that when I connect with one of these accounts (that do ... not work) from an outlook client I am attemting to receive mail. ... > POP client - only the Exchange server for POP, ... > Internet - this is entirely different. ...
    (microsoft.public.exchange.admin)