HELP, dont know how to describe this in a subject line
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 |
All times are GMT +1. The time now is 01:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com