Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to tranpose table
Please help me with vb or macros to tranpose Table 1 to Table 2 for any
number of entries. The courses in a row should be made into only one course in a row as shown in Table 2. Table 1 Trainer Room 25-Jun-05 26-Jun-05 27-Jun-05 28-Jun-05 29-Jun-05 Trainer1 Room1 CSB00 CSB00 CSB00 Trainer2 Room2 CSB01 CSB01 Table 2 Trainer Room 25-Jun-05 26-Jun-05 27-Jun-05 28-Jun-05 29-Jun-05 Trainer1 Room1 CSB00 Trainer1 Room1 CSB00 Trainer1 Room1 CSB00 Trainer2 Room2 CSB01 Trainer2 Room2 CSB01 -- JA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to tranpose table
I don't think this is exactly what you need, but it'll help
Sub Macro8() Range("M1:P7").Select 'What to copy Selection.Copy Range("Q2").Select 'Where to paste it Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tranpose data from columns to rows | Excel Worksheet Functions | |||
Excel 2002: Any formula to tranpose columns into rows ? | Excel Discussion (Misc queries) | |||
how do i tranpose one row to multiple column? | Excel Worksheet Functions | |||
Tranpose? | Excel Discussion (Misc queries) | |||
Open txt file with more than 256 columns (how to tranpose in rows)? | Excel Discussion (Misc queries) |