Friday, April 4, 2014

yogi_Consolidate Into one Master Table Hours Worked By Employees Listed In Various Tables

                                         Google Spreadsheet   Post  #1587 
                                                 (updated Oct-24-2015)
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Apr-04-2014
post by Ben Kwok: (!mydiscussions/docs/sAS1e-GzXqQ)
Consolidating tables across multiples sheets?
Hi all,

I have a table on Tab 1 and a table on Tab 2, and I'm trying to consolidate the information on these tables into one master table. I've been able to merge them into one large master table so far with VMerge, but it duplicates certain rows.

For example, these tables list scheduled hours for employees, and I have Employee A on both tables. I want the master table to have Employee A show up on 1 row with the total hours from both tables. Is there a way I can use a formula to do this while maintaining the ability to add more rows to the individual tables as needed?