retrieving values from a specified sheet

[Guest]

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

 

[Sean]

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

 

[Pete_UK]

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

 

[Guest]

Thanks Sean....

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

Thanks again
Anift

 

[Guest]

Thanks Pete,

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

Thanks a ton