Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Is this possible on excel?
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Is this possible on excel?
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 "pdfervent" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|