Looping Macro

Hello all,

Need a little help writing a macro that will run through a report and change the following:

If Col D = “Open”, then change to “

If Col D = “Open”, then Col E changes to “Y”, Col F changes to “Y” and Col G changes to “N.”

Please see attached workbook DatesReport for before and after versions. Would need this to loop through over 3K rows.

Thanks for any and all help!

Thanks TMshucks,

Unfortunately, this macro deleted all rows except the ones marked "open."

I was trying to keep all rows where they are, just change "Open"