![]() |
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 |
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 |
All times are GMT +1. The time now is 09:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com