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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ref Formula 4
Copy formulas in Column 1
Creating A List of Items Between Two Numbers 2
Code to format cells on several worksheets 2
formula help 2
Excel Copy COUNTIF while retaining reference 7
heperlink cell and cell content 5
Fill formula down for cells 74 rows apart 3

Back
Top