sorry for the confusion, i would like to the code to filter out rows that contain OFM and KH in column A and also filter out rows with Collar & Cuff in column M.
so that the excel would not delete these rows.
for the duplicate part, what i meant was for example in the external workbook, in this case, there is 5 rows to be copied over. Hence no matter how many times i click on the button, the excel worksheet would only show the 5 rows. however in this code now, if i click the button again, it would copy over the same 5 rows below the previous one.
i have attached a excel worksheet example of what happens if i click on the button three times. it shows that the same 5 rows three times. those in red are suppose to appear only once
|