Hello everyone,

I have a problem, i have a formula in one worksheet wich gets data from
another excel file: =+'C:test.xls]Worksheet1'!A8
The worksheets in the two files are exactly the same so my question is
can i replace Worksheet1 in the above formula so he takes the current
worksheetname of the current worksheet-file?

Kind regards,

Borrie


--
borrie
------------------------------------------------------------------------
borrie's Profile: http://www.excelforum.com/member.php...o&userid=37717
View this thread: http://www.excelforum.com/showthread...hreadid=573045