Drop down list section to go to row

[ButteCntyGuy]

I've seen this topic but not sure how to make it work. I'd like to add a drop down list to a spreadsheet. When an item is selected from the drop down I'd like the row that has the item from the drop down to be selected. Is that possible? I know how to create the drop down but I don't know how to get it to select a row.

[ajryan88]

Hi,

You would need to create a macro (using VBA) to do this. Please see the attachment.

To view the associated code, right click on the worksheet name in the tabs, and select "View Code". The code is commented so that you can understand it if you're not familiar with VBA.

Hope this helps