Data from one worksheet appearing on another

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

Guest

How do I make data from secondary worksheets appear on my main worksheet? i.e. - I have a budget breakdown that contains a cell with a @sum formula. I want the contents of that cell to appear on the budget summary sheet - and i need it to reflect any changes that made be made to the original cell.
 
Hi
in your target sheet enter the equation sign '='. Now select with your
mouse the other worksheet and source cell. Hit enter

You should see a formula like
='sheet2'!A1
 
='OtherSheet'!cell_with_sum

--

Regards,

Peo Sjoblom


Map Hammonds said:
How do I make data from secondary worksheets appear on my main worksheet?
Click to expand...
i.e. - I have a budget breakdown that contains a cell with a @sum formula.
I want the contents of that cell to appear on the budget summary sheet - and
i need it to reflect any changes that made be made to the original cell.
 
Right click the cell with the sum formula, and choose "Copy".

Navigate to the WS and cell where you wish this cell to be duplicated.
Right click in this cell and choose "PasteSpecial", and click on the
"PasteLink" button ... And you're done!
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

How do I make data from secondary worksheets appear on my main worksheet?
i.e. - I have a budget breakdown that contains a cell with a @sum formula.
I want the contents of that cell to appear on the budget summary sheet - and
i need it to reflect any changes that made be made to the original cell.
 

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

How to Populate Data from a table to another 0
Extract & compare data on different worksheets 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
formulae in excel worksheets 4
Passing data to an event handler 3
Copy worksheets and save files dynamically 3
Summing up various Worksheets to one Summary sheet using variables 1
using data from one worksheet in another worksheet 1

Back
Top