Data from one worksheet appearing on another

M

Map Hammonds

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

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
 
P

Peo Sjoblom

='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.
 
R

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