No cells in column A contain OFM
and KH.
I suspect the filter operator should be xlOR,
and you've changed things from the original file displaying rows where A is
not OFM to displaying rows where A
is OFM,
and neither line displayed after filtering for OFM or KH has Collar & Cuff in column M.
So, I'm not sure what it is you want the filters to do, can you put into words, what should be displayed on screen after the filters have been applied.
Quote:
and whenever i click on the button it would paste the same row again.
it there a way for it to not have duplicate?
|
Excel has a built in Remove Duplicates function on the Data Ribbon in the Data Tools section.
Also, please alter the
clear what's left section of code to be
Code:
' clear what's left
On Error Resume Next 'suppress error notification in case nothing visible
.Offset(1).SpecialCells(xlCellTypeVisible).ClearContents
On Error GoTo 0 'remove suppression of error notification