adding worksheets together

G

Gary

I have two worksheets with the same column config. I would like to add the 2
together and wind up with a master(and be add others to it later) as well as
the 2 orginals.................Gary
 
B

bigwheel

Something like this? Cell A1 on sheet 3 would have the formula
=Sheet1!A1+Sheet2!A1

The copy the formula to all other cells where you want
 
Top