Macro to clear data in certain columns if conditions exist

[jebucher]

Greetings,

I am trying to delete data in columns K, L and M on the attached sheet. The data needs to be deleted only if the corresponding data in the same row, column J is not present. For example, if row 10, column J is blank, then row 10, columns K, L and M need to be blank also. I know that this is some sort of if, then, else loop but I do not know exactly how to code it in VBA.

The result should make the graphs on the side much more readable without manually going through the document to clear certain data bits. (I had to delete the graphs in the test data because the sheet was too large)
Any help will be mightily appreciated.


Thanks,

JB

[HSV]

Will this do the trick for you ?

Please Login or Register  to view this content.

[jebucher]

That should work, thanks.

[HSV]

Please don't forget to mark the thread solved.
Thanks.