I have a list of names in Column K, maybe 25 different names all repeating and broken up amongst 600 rows. I want VBA to scan through the column and create a new list of all the names in the list without repetition. For instance there may be 20 rows in a sequence of one company, the list is scattered and broken up with spaces etc.
So I would think it would have to go through each row down the column and check the list that is made somewhere else if it is not on the list then to add it to the list.
I want it to stop running through the Column K when it hits the word "End".
I understand that I will have an
That is very crude but is this the right way to do it. The CopyToList is some generic list that the program would make of the company names maybe in Sheet1.Column X
Bookmarks