Same result on two worksheets

  • Thread starter Thread starter Patrick Murray
  • Start date Start date
P

Patrick Murray

I have four worksheets in a spreadsheet and the first sheet his a summary of
the totals from the other three. I would like to have the total on one
worksheet also appear in its proper cell on the first worksheet. In other
words, I would like to have a cell on the first sheet refer to to a specific
cell on a seperate worksheet. Any ideas???

Thanks
Patrick Murray
 
This is assuming your total on Summary sheet is in Cell A1
you can paste this into any sheet and get the value in summarysheet cell A1
=Summary!A1
 
Sorry I thought your sheet was named summary trythis and you can change
sheet2 to 3 and so on
=Sheet2!A1
 
Back
Top