Retriving Values from a separate sheet of a different file

[Anift]

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

"Anift" <Anift@discussions.microsoft.com> a écrit dans le message de
news:3D58ACF5-6413-4B77-8DC1-5E92CBDA485B@microsoft.com...
>
> 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..
>
>

[Anift]

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" <Anift@discussions.microsoft.com> a écrit dans le message de
> news:3D58ACF5-6413-4B77-8DC1-5E92CBDA485B@microsoft.com...
> >
> > 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..
> >
> >
>
>
>

[FSt1]

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