can someone tell me why this isnt working?

[samccune]

sorry alison, i know how to do that... look again.

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

what i'm trying to do, is call the information from column D on Sheet1,
but to use the number in Sheet5$A$1 to define the row number from which
to call on Sheet1. So if:

Sheet5!$A$1 = 7

then i would be calling the information from

Sheet1!$D$7

but if

Sheet5!$A$1 = 8

then i would be calling the information from

Sheet!1$D$8

see where i'm going with this? that way when i go in and change the
value in Sheet5A1, it will change the row in which the information is
called from on Sheet 1, very much like a database, though this is
really my first experience with either excel or a database.

anyone who can help in a way that my sorry a$$ can understand is MUCH
appreciated.

thanks
Scott

 

[Mark]

hmm,



sheets(1).range("D" & sheets(5).range("A1").value).select