Data from one worksheet appearing on another

[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.

 

[Frank Kabel]

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

 

[Peo Sjoblom]

='OtherSheet'!cell_with_sum

--

Regards,

Peo Sjoblom

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.

 

[RagDyeR]

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.