In an excel sheet some column cells are blank then corresponding blank cell

[aligahk06]

Dear All,

In an excel sheet some column cells are blank then corresponding blank cell entire should deleted.
for eg: column C cell c2 , c5, c7 ,c6 and so on are empty cell. I want to delete this particular empty cell deleted.

Any Idea.

Thanks,

Rgds,
aligahk06

[Aussiebear]

In an excel sheet some column cells are blank then corresponding blank cell entire should deleted.

What makes a cell "corresponding"? Next cell, cells or row, and in which direction?

for eg: column C cell c2 , c5, c7 ,c6 and so on are empty cell. I want to delete this particular empty cell deleted.

From which direction does the cell get filled from? Are we shifting a group of cells?

As you can see we need more detail from you, and if possible a dummy workbook to work with to assist you.

[aligahk06]

What makes a cell "corresponding"? Next cell, cells or row, and in which direction?From Top to down. Column verticalFrom which direction does the cell get filled from? Are we shifting a group of cells? As you can see we need more detail from you, and if possible a dummy workbook to work with to assist you.

[vcoolio]

Hello Aussiebear,

A duplicate post perhaps? Have a look a couple of rows down from this one in the Excel forum list.

Cheerio,
vcoolio.