Hi, Can anyone help on the below macro code.
I have the data like below,
<tbody>
</tbody>
and the result should come as below,
<tbody>
</tbody>
I wrote a code as,
Sub Macro3()
'
' Macro3 Macro
' extraction
'
' Keyboard Shortcut: Ctrl+i
'
Range("B1:B11").Select
Selection.Copy
ActiveSheet.Next.Select
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
ActiveSheet.Previous.Select
Range("B13:B23").Select
Application.CutCopyMode = False
Selection.Copy
ActiveSheet.Next.Select
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
It is taking only the particular range, but i have N number of data and it will get added more in future.
Can anyone help on this.
Thanks.
I have the data like below,
Name | ABC |
Model | DEF |
City | GHI |
Place | JKL |
KM | |
Condition | MNO |
1st Owner | |
2nd Owner | PQR |
3rd Owner | |
Price | STU |
Delivered | 11111111 |
Name | XYZ |
Model | DJFHA |
City | SAHJA |
Place | SHJ |
KM | |
Condition | SAFH |
1st Owner | |
2nd Owner | SAHJA |
3rd Owner | FGH |
Price | DJFHA |
Delivered | 11111111 |
<tbody>
</tbody>
and the result should come as below,
Name | Model | City | Place | KM | Condition | 1st Owner | 2nd Owner | 3rd Owner | Price | Delivered |
ABC | DEF | GHI | JKL | 20 | MNO | PQR | STU | 11111111 | ||
XYZ | DJFHA | SAHJA | SHJ | 5 | SAFH | SAHJA | FGH | DJFHA | 11111111 |
<tbody>
</tbody>
I wrote a code as,
Sub Macro3()
'
' Macro3 Macro
' extraction
'
' Keyboard Shortcut: Ctrl+i
'
Range("B1:B11").Select
Selection.Copy
ActiveSheet.Next.Select
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
ActiveSheet.Previous.Select
Range("B13:B23").Select
Application.CutCopyMode = False
Selection.Copy
ActiveSheet.Next.Select
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
It is taking only the particular range, but i have N number of data and it will get added more in future.
Can anyone help on this.
Thanks.
Last edited: