Scripts: Asp :: Excel macros (vb.net) :: Library Article #19
Developer's Section
![]() By: Erobo Software
|
|||||||||||||||||
![]()
In the code below we create a macro that reads Sheet1 and outputs Sheet2 with the items rearranged in a way that the items in Column 1 are Paired with each of the items in Column 2.
New Data After Macro Applied
Code: |
|||||||||||||||||
|
|||||||||||||||||
![]() |
|
System Message:
|
![]() the form below: |