= INDIRECT ("'" & $B$10 & "'!b2")

[Vincent]

Hi everyone.

I´m trying to drag that formula down and right, but it remains the same. My
Objective:
A
B
1 =INDIRECT("'" & $B$10 & "'!b2") =INDIRECT("'" & $B$10 & "'!c2")
2 =INDIRECT("'" & $B$10 & "'!b3") =INDIRECT("'" & $B$10 & "'!c3")
3 =INDIRECT("'" & $B$10 & "'!b4") =INDIRECT("'" & $B$10 & "'!c4")
....
65536


Thanks in advance

 

[Adilson Soledade]

As far as I could understand in cell $b$10 you have the name of a worksheet.
Try this aproach for cell B1 and drag it for the other cells

=INDIRECT(ADRESS(ROW(B1)+1;COLUMN(B1);1;;$B$10))

 

[Ron de Bruin]

See this example where I use Row()
http://www.rondebruin.nl/linksum.htm

 

[PCLIVE]

One way:

=INDIRECT("'"&$B$10&"'!" & ADDRESS(ROW(2:2),COLUMN(B:B)))

HTH,
Paul

 

[T. Valko]

Try this:

=INDIRECT("'"&$B$10&"'!"&CHAR(65+COLUMNS($A1:A1))&ROWS(A$1:A2))

You don't say how far you want to copy across. The above will work for
references *up to column Z*.

 

[Vincent]

Thanks a lot for all the answers.

Valko, your formula works fine, but isn´t as practical as the others.

Ron, that site is great but it didn´t answer my exact problem. Still, it´s a
great explanation. I guess i could solve my problem through logic with that
row example.