I am trying to use Advance filter option in macro, to get unique entries in range of collumn, and then use that array as entries to loop through the code for exporting tables to PDF.
Export to pdf (1st code) works. I just can't figure how to refer the unique values of filter for search and naming of exported pdf.
2nd code is for Advanced autofilter. SO far I was able to find how to copy unique cells to specific location.
But linking that to loop (preferably without pasting anywhere, would be a solution here. Can someone help me with this?
HTML Code:
and this next piece of code is for finding AdvancedFILTER unique values:
HTML Code:
Bookmarks