Sort by a column dependent on header value

[KrisHlebak]

I have a price list that could contain anywhere from 1 price, to up to 6 prices, based on volumes.

The program we are extracting the data from puts a header in each column with a sucessively increasing number (Price Vol #1, Price Vol #2, Price Vol #3).

I need the macro to search through these column headers, find the highest number in the header, (from example above "3") and then sort that column from lowest to highest.

I have attached a piece of my sample data (PricingList.Raw) that I need to sort. I first need to sort by part number, then by the highest price volume.

I have also attached a copy of what the data should look like (PricingList.Final). Which I manually sorted by Part number (Column A) and then Price Volume #4 (Column I).

[Mumps1]

It looks like the highest number in the header will always be the last used column. Is this true?

[KrisHlebak]

Yes. That is true.

[Mumps1]

Try:

Please Login or Register  to view this content.

[KrisHlebak]

I stand corrected, the column I wish to sort by will never be the last column used. It is embedded within a larger table of data, I just extracted the four columns of pricing for an example.

See attached for actual data that will be used. It is extracted from our program as a .cvs file and then saved as an excel file once formatting is complete.

The columns the pricing is located in are columns P, X, AF and AN.

In this example, I would like to look at all the headers, identify which column header has the highest value (#4) and then sort by that column.

[Mumps1]

Try:

Please Login or Register  to view this content.

Re-save the file as a macro-enabled Excel workbook so its extension changes to "xlsm".

[KrisHlebak]

That worked! Thank you very much!

[Mumps1]

You are very welcome.