adding worksheets together
 

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

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

"Gary" wrote:

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