I need to search my CSV file for "130 items selected". The 130 is a variable number so I really only want to look for items selected. I will be searching column "A". If found I need to remove all data from that corresponding row. Could somebody help with a macro for this. How can I get the macro to run each time new data is loaded in this workbook. Thanks in advance