I am not good enough to write the code to do this. I tried "record Macro" but this wouldn't work (it exceeded memory?).
The worksheet has multiple columns (fixed number) and unkown number of rows (data is imported). the 1st row is a header with autofilter on.
First,
I want to make the autofilter select the rows. Then delete the rows meeting that criteria. This is what I get from "record macro";
ActiveSheet.Range("$A$1:$AP$447").AutoFilter Field:=42, Criteria1:= _
"=Documents Printed", Operator:=xlOr, Criteria2:="=Planned"
But I the range needs to be selected based on the number of rows (changing each day).
Secondly,
After the data is filtered, I want to remove duplicates based on a single column.
I can do this manually but don't know how to write it into code for the macro.
I really appreciate any help.
Bookmarks