On Button Click goto

[rfletcher35]

Hi Guys I'll try to explain this properly

I have a main page that allow people from a drop down to choose a Product, then from a drop down in the next cell an item. I have then added a button.
I am wanting this button once clicked to go to a specific location on another sheet based on the 2 chosen items from my drop downs?

Does this make sense?

Please help

Fletch

 

[My Aswer Is This]

We always need specific details.

You said:

I have a main page​

What is the name of this main page?

You said:

from a drop down to choose a Product​

Do you mean a data validation list

What column is this list in?
I need something like this: Column A or Column B

You said:

then from a drop down in the next cell an item​

Do you next cell to the right?

What will we find in these drop downs?

Are these sheet names?

You said:

go to a specific location on another sheet based on the 2 chosen items from my drop downs?​

Tell me what will be in these two drop downs.

One I assume must be a sheet name and what is in the other drop down?