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 "Sheet1" or "Sheet2:, both in cell A4.
On "Sheet 3" place the sheet number that you want to refer to in cell B6 and
place the following formula in another cell
=INDIRECT("Sheet"&B6&"!A4")

Hope this helps.

Sean


"Anift" wrote in message
...
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

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.

Pete

Thanks Sean....

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

Thanks again
Anift

"Sean" wrote:

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 "Sheet1" or "Sheet2:, both in cell A4.
On "Sheet 3" place the sheet number that you want to refer to in cell B6 and
place the following formula in another cell
=INDIRECT("Sheet"&B6&"!A4")

Hope this helps.

Sean


"Anift" wrote in message
...
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

Thanks Pete,

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

Thanks a ton


"Pete_UK" wrote:

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.

Pete