I have a worksheet named "List" that contains data (text and numbers) in
column A and column B. I'd like a macro with a click button to create a new
tab with the name equivalent to the value of cell B6 on the worksheet "Unit
Names" and based on a worksheet called "Template". The data in column A of
"List" needs to be added to the new worksheet, transposing the value of cell
A1 on List to cell B1 on the new worksheet while the data in cell B1 needs to
be added to B2 They then need to be continued across the rows. So A1=B1,
A2=C1, A3=D1 and So B1=B2, B2=C2, B3=D2, etc.

Many thanks in advance