Consolidate Rows that have formulas in them but are blank w/ a macro

[HArley132]

Hey Everyone,

I am looking for some VBA programming that will allow me to use 1 button to consolidate rows (delete them). The problem I am running into is that the rows I want to delete have formulas in them so I can use "find all blank cells & delete" type of macro.
Capture.PNGCapture1.PNG

Attached are a couple of brief images on a small scale what I am looking to do.

End Goal:

I want a user to be able to have this sporadic list of choices, consolidate them so the are all one right after each other, then export to a word file for editing later on.

THANKS FOR THE HELP!

[RudiS]

Hi,

Try this macro. Please test on a copy of your data to verify.

Please Login or Register  to view this content.