can someone tell me why this isnt working?

[samccune]

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

trying to use the data (which is just a single number) in Sheet5 cel
A1, as the row number reference to call information from Sheet1 cell
(whatever is in Sheet5 A1)

the reason being i'm going to repeat this line in multiple places, the
when i change the data in Sheet 5 A1 it will change all of the instance
of this reference

 

[Frank Kabel]

Hi
INDIRECT won't work for closed workbooks. See the following thread for
alternatives
http://tinyurl.com/2c62u
(In your case INDIRECT.EXT should work)

You may also try to use something like the following (not tested
though):
=OFFSET('C:\PCS Connection\[Company Discounts.xls]Sheet1'!$D$1,'C:\PCS
Connection\[Company Discounts.xls]Sheet5'!$A$1-1,0)

 

[Ron Rosenfeld]

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

trying to use the data (which is just a single number) in Sheet5 cell
A1, as the row number reference to call information from Sheet1 cell D
(whatever is in Sheet5 A1)

the reason being i'm going to repeat this line in multiple places, then
when i change the data in Sheet 5 A1 it will change all of the instances
of this reference.

Probably missing some quotation marks in the last 'phrase'.

Try:

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


--ron

 

[Guest]

hi,

I think I have done this before.

In the cell where you want the data from sheet 5 enter:

sheet5!$a$1

Let me know if this works for you.

(e-mail address removed)