I have an Excel sheet in which I need to rearrange columns based on a cell value within that column using a Macro. What I mean is, I need the columns in a specific order (thanks to Access). It seems that the Excel report keeps changing based on user preference. The only constant is the text in Row 1. It always have the same values from report to report. I have attached two spreadsheets, one is the template, the other is a different order. I just want to get #2 to look like #1. Of course, the row length will vary from report to report. Is this even possible? I was thinking some HLookups and VLookups in combination, but couldn't figure it out.
Thanks for any help you can give me.