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

"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

Sorry I thought your sheet was named summary trythis and you can change
sheet2 to 3 and so on
=Sheet2!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