Scripts: Asp :: Excel macros (vb.net) :: Library Article #19
Developer's Section
Creating an Excel Macro to Redistribute Data By: Erobo Software
|
|||||||||||||||||
In this tutorial we create an excel macro that is going to take two columns and redistribute the contents of them using a macro that reads them.
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: |
|||||||||||||||||
|
|||||||||||||||||
See other Scripts in Excel macros (vb.net) |
Submit Your Scripts: |
System Message:
|
If you would like to have your ASP & ASP.NET scripts published in this section please fill out the form below: |