I recorded a macro to use Advanced Filtering but the Macro will not work.
When I recorded it, there were no issues and every time I run it manually it works.
There are no dates involved.
I am clearing any current data on the OutputSheet and then I am selecting a list of items on one worksheet and filtering out any duplicates so I am left with a unique list on the OutputSheet.
I position the cursor in call "A1" on "OutputSheet".
Code is below:
The input range includes a header (in F3).Please Login or Register to view this content.
The output position A1 is the header.
Bookmarks