Hello,

I am trying this for one day with the recorder and parts that i found on the internet but its taking me to much time to complete.

I want to copy an part of of row (B1:L1)from the workbook1 where i am in to an existing workbook2 (that is closed) in an certain row sextion (L2:W2) .
Then save the edited workbook2 as name of cell B1 (or L2), print worksheet 6+7, close file and repeat it for the next row (B2:L2).
This should be done until the first or one of the cells where it look are empty.

Can somebody help me?

Thanks