Move Contents of Cells and Eliminate Empty Rows

[aviatecar]

Hi Gurus:

I am trying to move contents from a specific cell to another and delete any empty rows produced(see attachment for illustation).
Please write me a code for this task.


Many many thanks,

Chris

Sample Datasheet for Code Request1-Conditioned data shift and empty row elimination.xlsx

[StevenM]

Backup data.
Copy code to standard module.
Run: IfBnDareEmpty

Please Login or Register  to view this content.

[aviatecar]

OH I LOVE YOUR CODES!

Thank you again for your timely and precise response!

Enjoy the weekend:-)