Hi,
I have an excel file in which i have data for 7000 rows. I only need the data up to a specific row. SO, for that I want to use a macro.

i want to delete or Clear contents below a specific word (which is "Pro Production") is found in Column A.

Please help