delete cell if condition is met

[jomili]

This one should be easy, but I'm drawing a blank. I have columns of data. What I want to do is this: If A1 is empty, delete B1(or maybe C1 or D1, depending on where I use this). Looking on the internet all I can find is how to delete an entire row.

[Richard Buttrey]

Hi,

Just filter your data for blanks in column A, then select all the cells in the filtered rows and hit the delete key.

Rgds

[jomili]

That would work if I were doing this manually. This is part of a much larger macro I'm writing for my users to be able to cross check two reports. I've attached a sample of what I'm working from. The idea is to boil out only the differences from the two reports

Columns A and B show the Posn Func code# and quantify from one report (APR)
Columns D,E and F show the same information and the title from another report (ESS)
Column H is the difference in quantity between the two.
Column C is what I'm working on now. I have a VLookup pulling the Posn Func title from the APR (based on if there's a value in B). What I'd like to do is one of two things:

A) Modify my vlookup to NOT display if there's a value in D or E.
OR
B) Clear the contents of C if there's a value in D or E.

Looking at the example, in this case the only titles I'd like showing would be the ones in C4, C7, and C9.

here's what my Vlookup looks like:

Please Login or Register  to view this content.

[jomili]

Okay, I guess I'll mark this one solved, 'cause I found an answer myself. The code below looks at the value in D, and if it's NOT empty it clears the contents of the corresponding cell in the C column.

For anyone else looking for this, to change it to where it deletes if the cell IS empty, just delete the "= False" part of the code.

Please Login or Register  to view this content.