Forum Discussion

jjohnson987's avatar
jjohnson987
Copper Contributor
Mar 09, 2020

adding data from worksheets into a master worksheet

Hello,

 

  I have a sign in for employees in a workbook that has a tab for each day in the week.  I am trying to bring all the data in each tab (the day tabs) to a master tab for a weekly total on each employee for payroll purpose.  Each day tab has the employee name and their employee ID and the total hours they worked that day.  Also, each day tab may not have the same employees on each tab as the payroll hours are for day work so there may be new employees each day to each tab.

 

How do I bring in all the unique data (employee ID) to the master tab so I can add their daily totals to the master tab for a weekly payout amount for payroll purpose?

excel

10 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Mar 09, 2020

    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?

    • jjohnson987's avatar
      jjohnson987
      Copper Contributor
      Mar 09, 2020

      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.

      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Mar 09, 2020

        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?

Resources