Follow this method to reference a cell on another worksheet (even in another
open file)
Type =
Open the source worksheet and click on the cell to get something like
=Sheet2!A1 or ='Jan Sales'!A10
Not the single quotes when the sheet name has a space in it.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Rich Hayes" wrote in message
...
In XP Excel I have 13 worksheet tabs, one for each month and 1 for a
summary.
On Summary tab I have 12 columns with the month name in each as written
on
the other 12 worksheet tab titles. Is it possible to reference a cell from
the summary page to; for example the January worksheet tab by linking the
cell on the summary sheet to the month name on the summary sheet.
Ultimately
what I'm trying to do is be able to drag the formula from the Jan column
across and for it to reference the Feb heading on the summary page but
pick
up the detail on the Feb worsheet tab. A formula in the summary sheet such
as
=(cellC5,J15) would reference c5 in the summary page which
would
have text of 'Feb05' in it and then cell J5 which would be on the
worksheet
Feb 05.
Hope this makes sense. Any help would be appreciated.
Regards
Rich