Ignoring Blank Cells But Keeping Index of Non-Blank Cells w/ Data Validation and ScrollRow

This uses an ActiveX combobox. Put the code in the worksheet's code module. It will populate the combobox with unique values from column A whenever there is a change to the column. It also stores the row number for each unique item in a 2nd hidden column within the combobox. Then when you select an item, it scrolls to the selected item's row.

After creating the combobox and pasting the code, make an initial change in column A to populate the list.

Please Login or Register  to view this content.

AlphaFrog, you are absolutely brilliant. This works flawlessly. Thank you so much for going out of your way to help me. Thank you again, much appreciated! :D

You're welcome. Thanks for the feedback.