Update Formula's based on drop down list value

[Steven Taylor]

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

 

[Pete_UK]

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

 

[Vasant Nanavati]

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.
_________________________________________________________________________

 

[Steven Taylor]

It worked!

Thanks guy's.

Cheers,

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.
_________________________________________________________________________