Copying cells from one sheet to another then filling down based on previous column

Hi There,

Don't suppose you can help me out.
I'm trying to find code for the following
Example attached
The Yellow Cells (which are the green ones just transposed), need to go to column M to column R in the Sheet 2.
They need to start in Row 2 and finish whatever the last row it.
This sample has 4 rows... some other jobs I have can have from 2 rows to 3000.

I'd prefer if the yellow cells I can get rid of, and some how just take the data from the green cells?
Workbook is attached: CHECKLIST.xlsm

Regards,
Mark

Hi,

Its determined by the number of rows. In this samples case 4 are required.


Hath

Rugs,
Mark

Hi,

I've uploaded a copy of what i'm trying to achieveCHECKLIST - FINAL.xlsm..... see how there is a row per existing data?

Regards
Mark

Don't suppose anyone has had alook?

Hi arlu

That is correct.

Button please.

Rugs
Mark