adding worksheets together

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

typing copies of worksheet together 1
How do you copy and rename linked worksheets? 1
Excel sorting logic 1
Pull info from multiple worksheets into one Master 2
Excel VBA 1
How do I sort linked cells ? 5
shorten worksheet name 1
Putting together worksheets 1

Back
Top