Drop down menu pointing to different worksheets?

[chrisko]

If I have several worksheets each having a customer name, is it possible to have one page have a drop down menu listing all customer names and when a customer is clicked on that worksheet will open?

If so, please explain how I can accomplish this.

Thanks,
Chris


Sent from my iPhone 5 using Tapatalk Pro

[sktneer]

Try this worksheet change event code......Assuming A2 has the drop down list on the sheet which has this code.....

Please Login or Register  to view this content.

For detail see the attached sheet.

[AliGW]

This can also be accomplished without a macro using a UDF and a validation list drop-down.

When referencing the cell with the drop-down, you'll need to use the INDIRECT function.

[chrisko]

Sktneer, thank you for the example sheet. I will try it out


Sent from my iPhone 5 using Tapatalk Pro

[chrisko]

What do I need to do to have the drop down on every page?

If the menu is on page1 and i choose page 5 it shows page 5. Now from page 5 i want to go to page 3.

Thanks,
Chris

[sktneer]

You can have the same drop down list in cell A2 of every sheet and paste the same code on every sheet's for worksheet change event.

[chrisko]

Ok thanks


Sent from my iPhone 5 using Tapatalk Pro