Jump Macro

[MikeG]

In Worksheet A, I have a cell (C3) where I enter a product number (1 to 5000). I would like a macro so that when I hit Ctrl j, I will then be taken to another Worksheet, B, which has a master list of all products. Based on the product number I entered, I want the macro to find the relevent row in the list and select the first column in that row. The first column is B and has the product number. The list is not necessarily sorted by product number all the time.

So for example, if I type 459 in cell C3, the macro will take me to the row for product 459 in the master list.

Thanks,

MikeG

 

[jbeaucaire]

You can actually do this without a macro.

Here's a page showing a formula method doing a Hyperlink to a row that matches a value on the current sheet. There's a sample file as well.

3D HYPERLINK()​

 

[MikeG]

You can actually do this without a macro.

Here's a page showing a formula method doing a Hyperlink to a row that matches a value on the current sheet. There's a sample file as well.

3D HYPERLINK()​

Thanks - that's neat.

Mike