I'm involved in a data migration project and I want to tidy the information in my CSV before uploading anything to the new system.
I have an excel sheet with over 50,000 entries (stock items) associated to suppliers by the supplier code number in column G.
I need to delete every line of stock associated to a supplier which I haven't purchased in the last three years. I have the list of suppliers (368 in total) and what I need to do is to delete every row where any of the 368 suppliers codes appears in column G.
Can someone help me with a macro that checks in my list of 368 and delete every row in which any of those supplier codes in Column G gives a positive match?