I have managed to create sub which is getting the visible contents of filtered column in a table, lets say Table1
then remove the duplicate entries
then from the unique list generate drop-down list in another sheet
the issue is that when the visible entries in the column doesn't contain duplicates i get error (relevant to red line below in code)i have commented (in the code) the lines where i was testing solution for unique listPlease Login or Register to view this content.
any ideas?
Please Login or Register to view this content.
Bookmarks