View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Same result on two worksheets

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

"Patrick Murray" wrote:

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