I looking for some help piecing together some macro as well as some extra code that I’m missing.
I currently have a worksheet (A) that is gathering it’s information from another worksheet (B) from the same workbook.
I need (A) to print then to go to (B), clear the top row, copy row 2 and paste into row 1 – (which will update (A)),delete row 2 to move the list up, then print the new results in (A). This needs to continue until it finds an empty row in (B) then it should stop.
Does that make sense?!?
I can write a macro for the copy/paste/delete and print, but do not know how to repeat the macro until the blank row is found in (B).
Thanks for reading