Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ref Formula
Good morning,
On my summary worksheet Cells A1:A50 are the names of the 50 other worksheets. I wish to insert Cell A1 of the repsective worksheets adjacent to the tab names in Column B, e.g. Cell A1 Sheet1 Cell B1 ='Sheet1'!A1 How would I change this formula to refer to column A on my Summary worksheet? Kind regards, Neil |