Linking data between sheets

O

Ozzie

Looks like you got your answer from others - keep in mind
that besides having the option to link different sheets
within a single workbook, you can also link different
sheets between different workbooks.



-----Original Message-----
I am going crazy trying to figure this out!
If I have data on mulitple sheets: say 1 cell from 6
different sheets that I am trying to SUM on a summary
sheet, what formula do I need to use?
Example:
Sheet x
sheet y
sheet z

add cell a5 from sheet x to cell b4 from sheet y to cell
b7 on sheet z and show the sum on the summary sheet.
 

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

Top