Dynamic linking (of 3 cells) while selecting from drop down cell

[siva venkata]

Dear all,

When I select Hardwar Platform (IBM,HP,SUN) from the drop down list, then only relative IBM or SUN or HP parameters should show from Processor model drop down list, in turn relative Processor speed should be selected from the Parameter sheet, and populate on the third cell i.e., (Select processor speed).

Please find attached sample excell for your understanding with example.

Thanks
Regards,

[Kaper]

It can be done just with built in funcionality. No VBA needed.
I defined 3 more named ranges (Ctrl+F3) called IBM, HP, SUN and assigned falidation list to =INDIRECT(C2) function.
see attached.

The thing which can be done with VBA is code for the sheet event Change, to check if visible value in C3 is appropriate to selected C2 and if not either empty it or fill with first value from current list.

[Kaper]

PS. the code for Sheet workout could be

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[siva venkata]

Thanks Kaper,

This is what exactly I am looking for. Thank you very much.
Can you please tell me the steps to create this Name manager and map to the required parameters.

[Kaper]

1 select range to be used as IBM (B4:B13)
2 Ctrl+F3
3 New
4 write IBM in Name field (field Refers_to will be already filled with =Parameters!$B$4:$B$13 because you selected it in step 1
5 OK
6 if more named ranges needed, goto 1 (of course nex will nor be IBM ;-) )

[siva venkata]

It really solved my problem and able to reflect the changes in original sheet.
Thank you very much Kaper....