i thought more about it and if I used the second sheet in the Compan
Discounts.xls workbook as the companyname.xls sheet could I then us
this:

=-INDIRECT("'C:\PCS Connection\[Compan
Discounts.xls]Sheet1'!$D$"&'Sheet2'!$A$1)

or would I need

=-INDIRECT("'C:\PCS Connection\[Compan
Discounts.xls]Sheet1'!$D$"&'C:\PCS
Connection\[Company Discounts.xls]Sheet2'!$A$1)

??

thanks so much for your help. I'm no longer at work so I cant reall
check how this works until sunday, unless I find a friends who ha
Excel and PP tomorrow

--
samccun
-----------------------------------------------------------------------
samccune's Profile: http://www.excelforum.com/member.php...fo&userid=1459
View this thread: http://www.excelforum.com/showthread.php?threadid=26340