Hello:
I am trying to create a spreadsheet that reads data on multiple sheets and creates a "summary" sheet with specific data from the sheets. The summary sheet will be uploaded to our payroll specialist and therefore needs to be in a specific format. I have attached a sample of the basic sheet that will be read (there may be anywhere from 5-20 of these in the spreadsheet).
I've also attached the final summary sheet we need to dump the data into.
Variables from the sample sheet:
Party (TEST PARTY) and Date (3 - 18)
Name (Worker ID number)
Hours worked
Pay rate
Total Hours
Tip
For each new party, rate, hours, etc., I would like the summary sheet to create a new line for the staff member showing the appropriate data. Is this possible to do with a formula? I was fine using a basic VLOOKUP until I needed to create new rows for each separate sheet/party.
Am I crazy to think this is possible?
Thanks!
I am trying to create a spreadsheet that reads data on multiple sheets and creates a "summary" sheet with specific data from the sheets. The summary sheet will be uploaded to our payroll specialist and therefore needs to be in a specific format. I have attached a sample of the basic sheet that will be read (there may be anywhere from 5-20 of these in the spreadsheet).
I've also attached the final summary sheet we need to dump the data into.
Variables from the sample sheet:
Party (TEST PARTY) and Date (3 - 18)
Name (Worker ID number)
Hours worked
Pay rate
Total Hours
Tip
For each new party, rate, hours, etc., I would like the summary sheet to create a new line for the staff member showing the appropriate data. Is this possible to do with a formula? I was fine using a basic VLOOKUP until I needed to create new rows for each separate sheet/party.
Am I crazy to think this is possible?
Thanks!