Drop-Down List - Then goto cell

[nono5551212]

I can't figure this out.

Say I have a drop-down list in EXCEL 2007 with the following items:

Invoice 1
Invoice 2
Invoice 3
Invoice 4

When a user selects the drop down list and picks an invoice number...
I want it to automatically go to a cell on the same worksheet.... say cell A95...

I would love to pull this off without using a macro.
But If I need a macro thats fine to...

Thanks for reading.
Hope you can help

[JBeaucaire]

You could use the HYPERLINK() function in an adjacent cell to your drop down to create a changing hyperlink that linked to the proper target. You would have to select from the drop down, then click the hyperlink. No macro.

To have it happen it simultaneously would require a worksheet_change macro watching that drop down cell.

[nono5551212]

Hoping to have the user do as little as possible...

Select from the drop-down..... then boom redirected to specific cell in the same worksheet...

Thanks for your response

[JBeaucaire]

What cell(s) have this drop down?
Do we simply match the selection made to the values in column A and jump to the cell that matches? Or is there some sort of lookup table somewhere?

[nono5551212]

Say in cell A1 I create a drop down (Data Validation > List > Invoice1, Invoice 2)
So I add the Invoice 1 & 2 right into the data validation.

Now when I click cell A1 a drop down appears
Invoice1
Invoice2

Say a user clicks Invoice2... soon as they click it.... I would like it to jump to cell b1000 (in the same worksheet)

[JBeaucaire]

Why cell B1000? My question before was specific. Unless you want to be manually editing this macro forever, it needs to be constructed in a way the selecting "Invoice 2" from the drop allows the sheet to evaluated in some way that "B1000" is the answer.

Does the make sense?

So, what is value of cell B1000? How does it relate to the text "Invoice 2"? Is there any correlation that is consistent enough that we can logically find the correct cell to jump to by making that connection between Invoice 2 and cell B1000?

[nono5551212]

This seemed to work
I created a combo box that drops down a selection... and used the below code.....

Please Login or Register  to view this content.

The 1-15 tags can be labled any way you wish via your combobox defined list.....
When selected it will add a 1-15 into a cell of your choosing....

[shg]

Cross-posted at http://www.mrexcel.com/forum/showthread.php?t=442266

Nono, you won't make any friends if you keep doing that.

[DonkeyOte]

and (in essence) also duplicated here... http://www.excelforum.com/excel-prog...cell-b100.html