As the title mentions, I am trying to find a way to find the 4 columns before last 6, copy and insert them right before last 6(these columns contain formulas). Once this is performed, go back to the columns copied and turn them into values and formatting.
The last 6 columns are always static and won't be removed. I tried writing an offset macro, I tried finding a macro on forums, but I failed miserably. Hopefully someone can help me with this.
I've attached a sample for reference.
Bookmarks