That is possible to do all in code, BUT, it will be slower than:I would like matching based off Column header name and not the position since the columns could change
Another sheet with a cross reference for Column Numbers. This XRef can be partially maintained with code(inserting the Column numbers,) but adding columns to be copied and pasted and Running the Maintenance code would have to be done manually. ie, Insert, delete or move any columns means you would have to Add or delete any such column header names from the XRef and Run the Macro, Probably by clicking a command button on the XRef sheet.
Note that MAFFT has ten more Green Columns than Deployment
Meter Read Date AI B&W Total Meter AJ B&W Print Total Meter AK B&W Copy Total Meter AL Color Total Meter Am Color Print Total Meter An Color Copy Total Meter AO Duplex Total Meter AP Double Click (11 X 17) Total Meter AQ Scan Total Meter AR
Reply With Quote