Macro to delete date in cell

**tracykay1** · 11-04-2011, 12:19 PM

Is there a way to write a macro that will delete data in a cell (A1) if cell B1 has data?

I have a spreadsheet that list forecast dates and completion dates. I do not want to count the forecast date if they have a completion date. Currently I am filtering and manually deleting the forecast dates if they have a completion date. Very time consuming! Can someone please assist in a macro that would do this for me? Attached is a sample spreadsheet.

Thanks in advance!

And Happy Friday!

**p24leclerc** · 11-04-2011, 07:12 PM

This macro will do what you want to do.

Please Login or Register  to view this content.

**tracykay1** · 11-08-2011, 03:01 PM

That worked great!! You are amazing! One more favor, how do I get it to do that for every other column? Just like the data in Column B was deleted if Column C had a date, how do I get that to work for Column D and E, Column F and G, and so on?

**p24leclerc** · 11-08-2011, 11:04 PM

This should work. I added the condition that the macro will stop when the first cell in row 2 and column B,D,F,etc is empty.

Please Login or Register  to view this content.

**tracykay1** · 11-09-2011, 11:40 AM

AMAZING!! That worked like a charm. You have just made my day as I have been working on this for several weeks. Cut my worktime in half. Thank you so much!