Create Macro based on Column Headings instead of Column Letter

Good Morning All.

I have a simple Macro that I use to quickly reorganize the data in a file... but the problem I am having is there are times where the original file has columns in a different order.... so the Macro does not always rearrange properly.

How do I make it so that instead of it just moving columns around, it will looking at the heading that the column has, and rearrange the data based on those headings?

Please Login or Register  to view this content.

Wow! That is awesome!

Thank you!!!

Wow! That is awesome!

Thank you!!!

Is there an edit that can be made to the code where it does not necessarily look at the "sheet Name"? In the example I posted, it was Sheet 1... but it is not always named that....

Sure use ActiveSheet instead of sheet name

Hello Again.

I have tried using

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

and am getting errors on this.

Where do i put/format the ActiveSheet name?

No no. You replace below worksheet reference

Please Login or Register  to view this content.

With...

Please Login or Register  to view this content.

You just have to make sure to run the code while you have the specific sheet active (the sheet in Excel window).

Have a read of link.
http://analystcave.com/excel-vba-wor...vs-worksheets/

That is awesome! Thank you for your help!