Convert crosstab data to regular list data using VBA in Excel. This is a very useful piece of code http://www.chicagocomputerclasses.com/convert-crosstab-table-database-list-table-excel-vba-macro-code/ Just record a dummy Macro in Excel and edit it. Replace with the code you find following the link. Then just highlight the data and run the macro. That’s it!
Monday, December 22, 2014
2103 Excellence
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment