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