Ref Formula Query
 

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

Ref Formula Query
 

An answer to your first question has been posted
Some of us in North America are just waking up!
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Neil Pearce" wrote in message
...
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