Hi. I'm new here, but I have a question that seems to me like it should have a simple answer.
I have several sheets in the same book. They are all timesheets, one for each employee. I'd like to create a master sheet that will pull all the raw data from each employee's timesheet. Each employee works on numerous jobs (listed by job number), and they vary from week to week, so there's no consistency. I may have more than one employee working on the same job. I do need all the raw data on the master sheet, but I still want to have individual timesheets, so just putting all the data into one sheet in the first place doesn't do me any good.
Is there any way to do this?
Thanks in advance.
Bookmarks