Forum Discussion
adding data from worksheets into a master worksheet
jjohnson987 May I ask why you collect data in separate tabs for each day of the week? Consider to collect all sign-ins in one single sheet, where one of the columns hold the date. Then you can analyse/summarise your data, for example, with a pivot table. Are you familiar with this?
Riny_van_EekelenI would love to have it all on one tab however, due to user issues we have found it easier for the people (our team leads) that is inputting to have the daily time on separate tabs. Our team leads are inputting into this spreadsheet through their phones. To alleviate many lines of data to search through and data inputting errors we are breaking down the reporting of the time to daily tabs.
I know how to bring in totals from the different tabs but just wasn't sure how to being in the unique identifiers on each tab to a main tab then do a VLookup for the daily time on the master tab.
jjohnson987 Not sure I follow. You mention that you "bring in totals from different tabs". Do you use a link? Or do you copy something manually? I imagine your ultimate goal is to gather all time records for all workers/employees into one data base, and I presume you don't want ot just copy/paste the daily records once they have been checked.
Could you upload an example of the file (delete any private information) you are working with?
Riny_van_Eekelenthank you for your help. Attached is the workbook I am working in. I have added the tab For Payroll Purpose and I am trying to get the employee IDs to the main tab then with vlookup bring in the daily time to the main tab for employees total time for the week. Then Payroll could copy and paste the weekly totals into our payroll software to pay out.
jjohnson987 Your VLOOKUP formulae are correct, though I changed one thing small thing. The IFERROR returns "0" if the ID was not found. I assume you want it to be the number -zero-, not a zero as a text.
There are no matching records in you daily tabs compared with column A in the Master sheet. To test your formula, I inserted an employee ID from the Monday sheet in row 3 on the Master. (See attached). I believe that it returns the correct result. Please make sure that the ID's for all employees in the daily tabs or in your master list. Let me know if I missed something.