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
 

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

Spreadsheet summary automatically referrences totals of worksheets 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How to Auto Reference Worksheet Tab ID's in Formulas? 9
summary values across worksheets within the same workbook 2
Have worksheet changes cascade down? 8
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Linking to other worksheets 3
Excel Highlighting duplicates 0

Back
Top