Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data transpose function
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
data transpose function
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose function | Excel Discussion (Misc queries) | |||
Transpose Function | Excel Worksheet Functions | |||
Transpose Function? | Excel Worksheet Functions | |||
Transpose Function | Excel Worksheet Functions | |||
How do I use the Transpose Function | Excel Worksheet Functions |