Hi. I'm new to this forum so I'll get straight to the point. I need a macro that can go through all cells between P2 and P25000 and if the value is equal to 1 in any cell then I would like the entire row of this cell to be deleted. If the value is NOT equal to 1 then I don't need it to do anything. The name of my workbook is called "Historical Data" and I want this macro to run on "Sheet 2". If anyone could please write a specific code that I could simply copy and paste it into a new module without any editing I would greatly appreciate it as I'm not a programmer! Please use the data I provided here to create the code. As for the name of the macro please use "Test1". I definitively need a macro for this as doing it manually is not an option for me. Thank you very much for all your help!