I have a worksheet, 'addresses', with two columns. Column A contains
formulae of the form
=IF(Aggregation!DD9<"",Aggregation!DD9,"")
|
|
|
=IF(Aggregation!DD1100<"",Aggregation!DD1100,"")

and column B contains
=IF(Aggregation!J9<"",Aggregation!J9,"")
|
|
|
=IF(Aggregation!J1100<"",Aggregation!J1100,"")

Some of the cells in column B are blank as nothing was entered in the
linked cell in the Aggregation sheet. I would like to be able to remove
all lines that have a blank cell in column B and then move the following
lines up to fill the gaps but have been unsuccessful with the macros I
have tried so far as the cells are not empty in that they contain a formula.

Is what I wish to do possible? Any help would be welcome!

TIA

--
F