My current macro identifies the columns I want to output and the order in which to do so as follows:
I am running into problems because the source data is no longer going to be in the same order consistently. There will always be a heading in row 1 and the values will remain to accurate to the data below so I want to use that value but can't seem to make it work. The result would end up something like:
I realize that I will end up needing to define these but I am not sure how to put it all together.