Check my *two* posts in http://www.mrexcel.com/board2/viewtopic.php?t=32254
You might have to adapt the code some to your specific need.

"Jackie" wrote:

I am trying to transpose data using VBA programming. Here is the example:

original data set:

Item Jun04 Aug04 Sep04
aaaa 10 9 11
bbbb 8 11 12

Transpose into a new worksheet

Item Month/year Qty
aaaa 7/2004 10
aaaa 8/2004 9
aaaa 9/2004 11
bbbb 7/2004 8
bbbb 8/2004 11
bbbb 9/2004 12

We can always use recordset to house a set of data and pass the recordset
aroud between tables in Access . How can I handle this in Excel and get data
paste into another worksheet?

Your assistance is highly appreciated,

Jackie