Hello,



I have a question if there is possibiliy to make folowing auomaticly instead of writing everying manualy.
I have worksheet called 'Dabase' that conains table. Each row of tabe has Unique number, lets say 111-222 in A2. In addition there is worksheet for each line in table called same (111-222).
I want to add one colum according to information from worksheets N1 cell.
At the momet I use somethng like: ='111-222'!N$1
I add 111-222 manualy but it is very time consuming and I am sure there is a way to get workshet number automatily from A colum.

Maybe you can help me with this? Thank you in advance.

Andrius

If I understand you correct:

=INDIRECT("'"&A2&"'!N1")

Cross post without links

http://www.excelguru.ca/forums/showt...from-worksheet

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post