Is this possible on excel?

  • Thread starter Thread starter pdfervent
  • Start date Start date
P

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
 
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
 
Back
Top