Formula to combine 2 spread sheets into one

  • Thread starter Thread starter dramon
  • Start date Start date
D

dramon

Is it possible to combine sheet 1 and sheet 2 into sheet 3? If it is what's
the formula?
 
Or you can put the formula below in the sheet 3 cell A1:

=SUM('sheet1:sheet2'!A1)

Thanks
 
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

Combining spread sheets with common fields 3
Combining multiple spread sheets into one 2
Linking Spread Sheets 1
Combine cells with the same reference and combine quantities 2
Complex formula help , please. 13
Excel Monthly Spread sheet. 12
Formula too large 4
problem with fractions to decimal 1

Back
Top