Ref Formula Query

  • Thread starter Thread starter Neil Pearce
  • Start date Start date
N

Neil Pearce

Cells A1:A50 on my Summary worksheet contain the names of the other 50
worksheets in my workbook.

I now wish to populate column B with the contents of Cells Z1 of the 50
workbooks, e.g.

Cell A1 =Sheet1
Cell B1 ='Sheet1'!Z1

How would I adjust B1 such that the formula would refer to cell A1 and that
therefore the cell can be copied and pasted?


Yours in appreciation,

Neil
 
An answer to your first question has been posted
Some of us in North America are just waking up!
best wishes
 
Back
Top