Retriving Values from a separate sheet of a different file

[Guest]

In one sheet, I have to create a Cell with
list box with all dates from Mar -1 to Mar -31 and I want to retrieve the
values from the same "Date" sheet of " daily Figures.xls " which has figures
of that particular date.

Let me give u one example:

Daily figure.xls has Daily Sales fugure in C1 of Mar - 2 Sheet ( One of the
sheet from Mar-1 to mar-31 ), All I have to select a date " Mar -2 on a
different file and it will give me value from that Date's Sheet in Daily
figure.xls from C1.

Any help in this regard..

 

[Ardus Petus]

Assuming your cell with date choice is in A1.
Enter in B1:
=INDIRECT(A1)&"!C1"

HTH

 

[Guest]

hi,
you might want to try a formula like this in the file you want to draw the
date into.

=('H:\dir1\[Daily Figures.xls]Sheet1'!C1)

you may have to modify the above to reflect the correct file path to Daily
Figures.xls.
note the use of brackets and single quotes.

regards

FSt1

 

[Guest]

Hello Petus,

With this Indirect function, I can move from one sheet to another of same
file, I have to retrieve value from a specified sheet of different file

Any suggestions