Excel copy down changing sheet number

G

Guest

Hi, i need to be able to copy down a formula that changes the sheet number
but not the cell reference. How can I do this?
E.g.
=Sheet2!A2
=Sheet3!A2
=Sheet4!A2

I thought about concatenating this together but don't know how to change to
a formula. Any other way of doing this?

If there is no way to copy surely there is a way to change a concatenation
into a formula -
="Sheet"&row()&"!A2"
but then what?
 
G

Guest

You've almost got it. Just enclose your formula inside the INDIRECT()
function.

=INDIRECT("Sheet"&row()&"!A2")

HTH,
Elkar
 

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

Top