software

Hi,
I have a file with 30 Worksheets for date March 1 to March 30, with some
daily sales data, Now I want a folmula by which I can retrieve the figure
from a particluar date's worksheet which I specify, or in other words, Is
there any formula where it can move from one sheet to another and retrieve
values.

any sugestions will be highly appreciated

Hi,

The INDIRECT function may do what you want.

As you did not provide enough details, lets say the data you want is either
on quot;Sheet1quot; or quot;Sheet2:, both in cell A4.
On quot;Sheet 3quot; place the sheet number that you want to refer to in cell B6 and
place the following formula in another cell
=INDIRECT(quot;Sheetquot;amp;B6amp;quot;!A4quot;)

Hope this helps.

Seanquot;Aniftquot; gt; wrote in message
...
gt; Hi,
gt; I have a file with 30 Worksheets for date March 1 to March 30, with some
gt; daily sales data, Now I want a folmula by which I can retrieve the figure
gt; from a particluar date's worksheet which I specify, or in other words, Is
gt; there any formula where it can move from one sheet to another and retrieve
gt; values.
gt;
gt; any sugestions will be highly appreciated
Check out the INDIRECT( ) function in Excel Help. With this you can
specify the address (including sheet name) of the cell you want to get
data from.

Hope this helps.

PeteThanks Sean....

This is what I was looking for you.. Kudos to u

Thanks again
Anift

quot;Seanquot; wrote:

gt; Hi,
gt;
gt; The INDIRECT function may do what you want.
gt;
gt; As you did not provide enough details, lets say the data you want is either
gt; on quot;Sheet1quot; or quot;Sheet2:, both in cell A4.
gt; On quot;Sheet 3quot; place the sheet number that you want to refer to in cell B6 and
gt; place the following formula in another cell
gt; =INDIRECT(quot;Sheetquot;amp;B6amp;quot;!A4quot;)
gt;
gt; Hope this helps.
gt;
gt; Sean
gt;
gt;
gt; quot;Aniftquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt; I have a file with 30 Worksheets for date March 1 to March 30, with some
gt; gt; daily sales data, Now I want a folmula by which I can retrieve the figure
gt; gt; from a particluar date's worksheet which I specify, or in other words, Is
gt; gt; there any formula where it can move from one sheet to another and retrieve
gt; gt; values.
gt; gt;
gt; gt; any sugestions will be highly appreciated
gt;
gt;
gt;

Thanks Pete,

I didnt know you can specify the sheet's name in that..

Thanks a tonquot;Pete_UKquot; wrote:

gt; Check out the INDIRECT( ) function in Excel Help. With this you can
gt; specify the address (including sheet name) of the cell you want to get
gt; data from.
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
gt;