Rearranging columns in a large spreadsheet
Hi,
I've got a large spreadsheet (goes to column CF), which is created
from another set of macros that pull in data from multiple sources.
After the spreadsheet is created, I would like to reorder the columns
in a more consumable order. How would I go about looping through the
columns to get the header names, and then putting the columns that I
want more to the front of the spreadsheet where the user will
immediately see the data when the workbook is opened? Thanks for any
advice.
Frank
|