Rearrange selected columns automatically

Hi Sujit,
Could you please attach a workbook to your thread? It would be nice to have one sheet being as you receive your data and another one with your manipulation done. This way, we can work a macro that will do it automatically.
Regards

Hi and welcome to the forum

If the headings will be EXACTLY same each time - even if they are in a different order - you cam probablu use the index/match/match functions to give you what you need. Play around with that for a while and if you still cant manage it, as p24leclerc suggests upload a sample workbook
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.