Retriving Values from a separate sheet of a different file
 

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..

Retriving Values from a separate sheet of a different file
 

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

HTH
--
AP

"Anift" a écrit dans le message de
...

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..

Retriving Values from a separate sheet of a different file
 

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


"Anift" wrote:


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..

Retriving Values from a separate sheet of a different file
 

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


"Ardus Petus" wrote:

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

HTH
--
AP

"Anift" a écrit dans le message de
...

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..