macro with transponing and next blank line copy

[01mercy]

Attached I have a excel file with my task list.

I want to make a macro from sheet one the first block fill in range to sheet 2 transponing the data and fill it in in the next blanck line.The same I want for block 2 in sheet one but then to the third sheet.

Can anyone help me with this?

Thanks

 

[N1GHTEYES]

Some of us cannot see your attached workbook because the security protocols where we work prevent us from opening it. So it might be helpful if you briefly described anything relevant from the workbook.

Your problem seems a little unclear; do you think you could state exactly what you are trying to do a bit more clearly? Perhaps you could break it down into individual steps?

Have you written any code yet? If so, please post it and say why you think it does not work, including any errors.

If you have not yet written anything, you might start by using the macro-recorder to record your actions while you manually do whatever it is you would like the macro to do.

Tony