Hello,
I have a large excel file with over 50 columns that is out of order when i downloaded from web. So web content management system scrambled all the columns, and when export to excel, all columns are out of order. Original data is a Form responses that exported out to excel. Unfortunately, Web CMA does not offer solution, so i have to unscramble columns with excel. I used Query to split the columns and manually ordered all the columns and managed to create a template. Now i would like to auto fill data to the template with corresponding columns. Is there any VBA code or procedure that i can automate or make it faster process. If VBA code does not work, i am open to any solution.
I have a large excel file with over 50 columns that is out of order when i downloaded from web. So web content management system scrambled all the columns, and when export to excel, all columns are out of order. Original data is a Form responses that exported out to excel. Unfortunately, Web CMA does not offer solution, so i have to unscramble columns with excel. I used Query to split the columns and manually ordered all the columns and managed to create a template. Now i would like to auto fill data to the template with corresponding columns. Is there any VBA code or procedure that i can automate or make it faster process. If VBA code does not work, i am open to any solution.
