I need to create a unique list of values from a column on one page and copy that to another page. Right now I'm using this code that I found online, and it's working perfectly:
However, there are some values that I want to filter (empty spaces "", general names like "Staff", and so-on). I tried using something like:Please Login or Register to view this content.
but it gives me an error. This makes sense I suppose since the copy command seems to be a direct command instead of a loop (I'm not used to a range being designated as "F:F"... I assume that means the entire column where values are present?). I tried filtering the column with a loop, but I kept getting errors. Also, as mentioned above, I also need to alphabetize the list once it's created on the second sheet. Any help would be appreciated!Please Login or Register to view this content.
Bookmarks