Hello!
It seems like a easy task but I have not been able to figure it out.
I have 4 identical tables. 1 I would like to be the Master table that adds all the data from the other 3.
I know how to put formulas in each cell of the master table to accomplish this but what I would like to know if there an way to add the tables instead of adding the cells. It would be must faster to do it this way.
This is how I would like it to work:
_____________________________
Master
auto mortgage checking
Jan 3 3 3
Feb 6 6 6
March 9 9 9
_____________________________
Sales Person A
auto mortgage checking
Jan 1 1 1
Feb 2 2 2
March 3 3 3
_____________________________
Sales Person B
auto mortgage checking
Jan 1 1 1
Feb 2 2 2
March 3 3 3
_____________________________
Sales Person C
auto mortgage checking
Jan 1 1 1
Feb 2 2 2
March 3 3 3
_____________________________
Bookmarks