The attached system generated file has a lot of garbage rows I'm trying to clear out using code. I need to have vba scan down COL A for a blank cell.
IF BLANK, look to the first filled COL D cell ABOVE IT and copy it's contents into COL A's blank cell.
Example: D3 would get copy/pasted down to A4 next to the invoice content line.

(the only rows of content I want to keep are the ones where Invoice#s are present-- BUT I need to bring the CUST NAME down and populate it into Col A before I delete the garbage rows like rows: 3, 7, 12, 20, etc.)



The next thing I need to do is delete all the blank rows like rows: 2, 5, 6, 10, 11 etc.)
The final thing is to COMBINE all the invoice amounts floating in COLS H,I, J, K

When all is done, it should look like the sample RESULT tab shown within the file.

Attached Files

fill-blank-with-above-data17.xlsm (20.1 KB, 13 views)