Relative path due to cell change

[knuck1es]

Hi greetings again,

well i am not sure wether this may even work without a makro but still i have a try.

For example the name of the Data is Bob.xls then it will be in the folder
Y:\...\Bob\2011\ba_bob.xls
and i need for example the cell A1 from this data.


so the idea was fo link it like.

c1=alice, d1= "=Y:\.....\"&c1&"\2011\ba_"&c1&".xls"
c2=bob .......
c3=oscar ...........

and then i just could copy d1 and move it down to link the full table.

is there a way? thx for your help and i am sorry for my aweful english skills.

[mahju]

Hi
For the better understanding please upload a sample file with input and expected results / oitput.

It will be better

Regards