Dynamic Alphabetical List

[nrguerrieri]

Hello,

I am trying to make a drop down list from a 10,000 row column in another sheet but in alphabetical order. Then when that name gets selected. It finds it in the list and strikethroughs the row with that business name.

Thanks,

Nick

 

[McGuilliam]

Unsure about your setup, but inserting an extra column were you put i.e. x's when checked would allow for a conditional formatted strike through. If needed this column can be "auto-filled" using a vlookup or index/match if names are used several times and you can keep a list of checked names.

 

[smozgur]

Duplicate question since the OP decided to continue the discussion in the following thread which has more information:

Formatting VBA Needed

Hello, So i have an excel table with 9 columns and 10,000 rows. I would like every row in column C to be searched and every cell checks the other cells in column C for any other cell with the same 5 starting characters and then each one that is the same as the other. Those cells have their...

www.mrexcel.com

Closed for further replies.