N
Neil Pearce
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
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