Automated Timecard

[Guest]

I am looking to start having my department do our timecards electronically.
What I would like to know is if there is any way to do the follow:

When the employee opens up the template they are able to go the the "Name"
field and choose their name from a list - than when they choose their name
other fields are populated automatically, such as manager, employee ID....

is this possible?

 

[Guest]

"Name" list could be done using Data Validation and cell population using
VLOOKUP (or INDEX/MATCH).

Need further details to give a more precise answer.

 

[Guest]

What information would you need to give a more precise answer?

 

[Peo Sjoblom]

First of all you need to create a table with all this information where the
name column is the leftmost column, then in all adjacent cells to the right
of the names there would be the rest of the info such as ID and manager etc,
Best would be to put this table in a hidden sheet then extract the name list
and hide it in the same sheet where you want this done. Assume you want the
dropdown in A2, the rest of the info in B2, C2, D2 etc

Assume you put the name list in column Z in Z1:Z250 (adapt to fit
accordingly)
Assume the table in the hidden sheet is called MyTable

Select A2, do data > Validation > Allow > List and put =$Z$1:$Z$250

in B2 put =IF(A2="","",IF(ISNA(VLOOKUP(A2,MyTable,2,0)),"No
Match",VLOOKUP(A2,MyTable,2,0))

Use the same formula in C2 but change the 2 after MyTable to 3 and so on
depending on how many columns you have in the table

--
Regards,

Peo Sjoblom