software

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 quot;Datequot; sheet of quot; daily Figures.xls quot; 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 quot; 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..
Assuming your cell with date choice is in A1.
Enter in B1:
=INDIRECT(A1)amp;quot;!C1quot;

HTH
--
AP

quot;Aniftquot; gt; a écrit dans le message de
...
gt;
gt; In one sheet, I have to create a Cell with
gt; list box with all dates from Mar -1 to Mar -31 and I want to retrieve the
gt; values from the same quot;Datequot; sheet of quot; daily Figures.xls quot; which has
figures
gt; of that particular date.
gt;
gt; Let me give u one example:
gt;
gt; Daily figure.xls has Daily Sales fugure in C1 of Mar - 2 Sheet ( One of
the
gt; sheet from Mar-1 to mar-31 ), All I have to select a date quot; Mar -2 on a
gt; different file and it will give me value from that Date's Sheet in Daily
gt; figure.xls from C1.
gt;
gt; Any help in this regard..
gt;
gt;
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

FSt1quot;Aniftquot; wrote:

gt;
gt; In one sheet, I have to create a Cell with
gt; list box with all dates from Mar -1 to Mar -31 and I want to retrieve the
gt; values from the same quot;Datequot; sheet of quot; daily Figures.xls quot; which has figures
gt; of that particular date.
gt;
gt; Let me give u one example:
gt;
gt; Daily figure.xls has Daily Sales fugure in C1 of Mar - 2 Sheet ( One of the
gt; sheet from Mar-1 to mar-31 ), All I have to select a date quot; Mar -2 on a
gt; different file and it will give me value from that Date's Sheet in Daily
gt; figure.xls from C1.
gt;
gt; Any help in this regard..
gt;
gt;

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 suggestionsquot;Ardus Petusquot; wrote:

gt; Assuming your cell with date choice is in A1.
gt; Enter in B1:
gt; =INDIRECT(A1)amp;quot;!C1quot;
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;Aniftquot; gt; a écrit dans le message de
gt; ...
gt; gt;
gt; gt; In one sheet, I have to create a Cell with
gt; gt; list box with all dates from Mar -1 to Mar -31 and I want to retrieve the
gt; gt; values from the same quot;Datequot; sheet of quot; daily Figures.xls quot; which has
gt; figures
gt; gt; of that particular date.
gt; gt;
gt; gt; Let me give u one example:
gt; gt;
gt; gt; Daily figure.xls has Daily Sales fugure in C1 of Mar - 2 Sheet ( One of
gt; the
gt; gt; sheet from Mar-1 to mar-31 ), All I have to select a date quot; Mar -2 on a
gt; gt; different file and it will give me value from that Date's Sheet in Daily
gt; gt; figure.xls from C1.
gt; gt;
gt; gt; Any help in this regard..
gt; gt;
gt; gt;
gt;
gt;
gt;