Is this possible on excel?

[pdfervent]

ok heres my prob...im using excel to keep track of payroll for 3 different
jobs and i was wondering how i can enter names, dates, times and rates on one
worksheet and have it generate a sign in sheet (that is standardized and
recreated in excel) with all the entered data for each seperate job on 3
seprate worksheets.

hope someone understands this...its driving me nutty

 

[Bernie Deitrick]

Use just the one sheet, and filter on your column of job id using Data / Autofilter then selecting
the job from the dropdown value.

HTH,
Bernie
MS Excel MVP