Thanks this is what i am looking for.
however the code still cannot auto filter for Collar & Cuff and whenever i click on the button it would paste the same row again.
it there a way for it to not have duplicate?
i have attahced the duplicated excel workbook
|