Hi,



I would appreciate some advise on the following:



1. I have a workbook with 5 sheets in it. The first four sheets are

named wk1, wk2, wk3, wk4. The fifth sheet is named Summary.

2. The "Summary" sheet has a drop down box on the sheet with the

names of the first four worksheets.

3. When a user selects a value from the drop down list say "wk2", I
would

like all the formula's on the "Summary" page now to pull the values from

the "wk 2" worksheet etc.



All comments and suggestions welcome.



Thanks,



Steve

You'll need to use the INDIRECT function, something like:

=INDIRECT($M$1&"!A1)

where M1 contains your pull-down. This will bring the value from cell
A1 of the sheet specified in M1.

Hope this helps.

Pete

On Jul 15, 12:20 am, "Steven Taylor" wrote:
Hi,

I would appreciate some advise on the following:

1. I have a workbook with 5 sheets in it. The first four sheets are

named wk1, wk2, wk3, wk4. The fifth sheet is named Summary.

2. The "Summary" sheet has a drop down box on the sheet with the

names of the first four worksheets.

3. When a user selects a value from the drop down list say "wk2", I
would

like all the formula's on the "Summary" page now to pull the values from

the "wk 2" worksheet etc.

All comments and suggestions welcome.

Thanks,

Steve

I think you missed the closing double quote. <g

=INDIRECT($M$1&"!A1")

Of course, this is assuming that it is a Data Validation dropdown.
__________________________________________________ _______________________

"Pete_UK" wrote in message
ups.com...
You'll need to use the INDIRECT function, something like:

=INDIRECT($M$1&"!A1)

where M1 contains your pull-down. This will bring the value from cell
A1 of the sheet specified in M1.

Hope this helps.

Pete

On Jul 15, 12:20 am, "Steven Taylor" wrote:
Hi,

I would appreciate some advise on the following:

1. I have a workbook with 5 sheets in it. The first four sheets are

named wk1, wk2, wk3, wk4. The fifth sheet is named Summary.

2. The "Summary" sheet has a drop down box on the sheet with the

names of the first four worksheets.

3. When a user selects a value from the drop down list say "wk2", I
would

like all the formula's on the "Summary" page now to pull the values from

the "wk 2" worksheet etc.

All comments and suggestions welcome.

Thanks,

Steve

It worked!

Thanks guy's.

Cheers,

Steve

"Vasant Nanavati" <vasantn AT aol DOT com wrote in message
...
I think you missed the closing double quote. <g

=INDIRECT($M$1&"!A1")

Of course, this is assuming that it is a Data Validation dropdown.
__________________________________________________ _______________________

"Pete_UK" wrote in message
ups.com...
You'll need to use the INDIRECT function, something like:

=INDIRECT($M$1&"!A1)

where M1 contains your pull-down. This will bring the value from cell
A1 of the sheet specified in M1.

Hope this helps.

Pete

On Jul 15, 12:20 am, "Steven Taylor" wrote:
Hi,

I would appreciate some advise on the following:

1. I have a workbook with 5 sheets in it. The first four sheets
are

named wk1, wk2, wk3, wk4. The fifth sheet is named Summary.

2. The "Summary" sheet has a drop down box on the sheet with the

names of the first four worksheets.

3. When a user selects a value from the drop down list say "wk2",
I
would

like all the formula's on the "Summary" page now to pull the values from

the "wk 2" worksheet etc.

All comments and suggestions welcome.

Thanks,

Steve