retrieving values from a specified sheet
 

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

retrieving values from a specified sheet
 

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

retrieving values from a specified sheet
 

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

retrieving values from a specified sheet
 

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

retrieving values from a specified sheet
 

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