Copy variable range from sheet to the last row with a specific blank column in new sheet

Hi all,

I want to copy the range of data on the "New" worksheet from A2, over to the last row which contains data in column K (note, formulas exist in column A, so it can't look for a completely empty row but simply the last row that contains data in column K).. then switch to the "Complete" worksheet, find the next row which contains a blank in column B, and then Paste/Special Values starting in that same row.

So - in the attached example, that would be copying cells A2 to K14 in "New", and paste them into the "Complete" worksheet starting at location B2.

And then, if the macro was run twice, it would copy the same range in "New", and then paste into "Complete" starting at location B15.

I don't think I've explained it very clearly but am really hoping someone can help as I've been trying to get this working for too long .. Thank you in advance!

excel-vba-copy.xlsm

Try this...

Please Login or Register  to view this content.

Sigh! So simple.. and flawless! Thank you AlphaFrog.