Rearrange columns with additional columns in required order with code

Originally Posted by RAJESH SHAH

I am still not ready to understand such professional code

As I wrote it's a simplified version, so at beginner level,
just using Excel basics - INDEX, IF & RIGHT worksheet functions - and only VBA basics
so all is yet explained in both helps …

My fastest way - but all hardcoded - may be slightly more 'professional' …

Originally Posted by RAJESH SHAH

If you are asking me to edit the code and create 5 more csv files and extract the data from the different source sheets then I think you are just imagining that I can do that.

No I did not imagine that as :

• this demonstration already exports all the 6 csv text files types from the five source data worksheets !
  
  
• No need to edit the code as nothing is hardcoded : all must be defined in the settings worksheet CSV !

Originally Posted by RAJESH SHAH

which line of code is creating the b2c file in the folder of each state. There is no mention of the file name nor any mention of the state code folders. How did you get the headings in the csv file that is another surprise ?

As just written above, the same codelines export all the csv text files types according to the settings from CSV worksheet.
Aka the Open and Print # codelines.

And for the settings : all is explicitly yet explained in the original post #111 …

As commented, described, explained, whatever, in posts #102, 107, 111, 118, 119, 158, 186 & 201
no need to edit the code with my demonstration …