Martin,

1. In a loop I need to insert 9 rows after each row (first row of data is
row 2). The total number of rows transferred vary on a case by case basis.

Which column is this based on?

2. Copy the data in the first row Column A to K into the empty 9 rows in a
loop

A to K is eleven columns, which won't fit into either 9 or 10 rows.... ?
And which column do you want the items tranposed into?

HTH,
Bernie
MS Excel MVP


"Martin" wrote in message
...
Hi everybody,

In a Macro I am transferring data from one worksheet to another. And this is
what I need to do after the data is transferred into the new sheet:

1. In a loop I need to insert 9 rows after each row (first row of data is
row 2). The total number of rows transferred vary on a case by case basis.
2. Copy the data in the first row Column A to K into the empty 9 rows in a
loop
3. The data in the (10) columns L to U need to be transposed in a loop into
column B
4. The data in the (10) columns V to AE need to be transposed in a loop into
column D

Any help much appreciated.

--
Regards,

Martin