Navigating to cells as per the Drop Down

[nbkjytr]

Hello Friends,

Need help with excel. Working on tracker with has too many information to scroll from left to right.

Hence looking for a method where I can directly go to specific cell based upon the value in drop down (Data Validation) without any double click or select and click. I think VBA would work smoothly.

Example if I select June in drop down it should take me to the cell where June data (K12) is available.

Note: All the Data is available in the same Sheet. It only needs to navigate to the specific cell in the same sheet. Only the source of Data Validation is in a different Sheet in the same excel file.

Attaching a sample screenshot for both the sheets for your reference.

 

[Micron]

In case anyone in the future is interested in using a combo for this (and assuming I understand the original problem), here's how:
Freeze panes set at column 3. Combo located inside frozen column range.

Combo rowsource. Numbers are for the leftmost column in the desired range which should lie outside of the rightmost frozen column, so 4.

Only one line of code is actually required.

Private Sub ComboBox2_Click()

'example of staying on a particular row, e.g. 1
Cells(1, ComboBox2.Column(1)).Select

'example of staying on the active row
'Cells(ActiveCell.Row, ComboBox2.Column(1)).Select

End Sub

After January selection:

After August selection

After Apr selection

Of course, you don't have to show the list values in the sheet.
HTH someone one day.