how to create a list that will depend on the sheet

[tonnerre2000]

Hi I would like to create a list depending on the sheet I choose.


For exemple I have the sheet name on colomn 1 and I want to automatically chose a list cell A1 to A999 on the sheet selecte on colomn 1

How can I do that?

Thank you

[Søren Larsen]

It sounds like you could use =INDIRECT(). If you have the sheetname in A1, then:

=INDIRECT("'"&$A$1&"'!"&ADDRESS(COUNTBLANK($A$1:A1)+1,1)) and copy down.