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
Click to expand...
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
Click to expand...
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

Similar Threads

External cell reference between two excel worksheets both in One Drive 0
How do you make a summary sheet? 0
Creating a template that I can reproduce every month by keying ininformation from SAP 8
Summing multiple validated sheets into a summary sheet 3
formula issues. 0
How to summarize copied data 2
Lookup whole sheet and add datas from specified date to end date 0
SUM function on multiple worksheet 5

Top