ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Is this possible on excel? (https://www.excelbanter.com/new-users-excel/210923-possible-excel.html)

pdfervent

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

Bernie Deitrick

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