I have created a sheet called WORK ORDER where all of my product options are
listed. I made it so that if an option was not picked, the cell that
contained that option would be blank. I then wrote a code that would
delete all blank cells in WORK ORDER. What I would like to have happen now
is have the new condensed list reach a certain point (A63) and the remaining
portion of that list move over to F14 and work its way down to cell F57 if
needed. If the list continues after F57 I would need the remainder to
start on J1.

I am having fits with this for some reason, so if anyone has a similar code
or knows how to go about this, it would be greatly appreciated.