Sort Select Range: Either Find Column Header or Last Column:Last Row

Please Login or Register  to view this content.

My code was hard coded to sort on Column F, and I just guessed by going to row 50 that it would go past my actual data. Today it failed and I realized it failed because my raw data had an extra column. The column I need to sort on is "Grand Total". Because of the extra column, it was now Column G instead of F. So apparently it may not be consistently in the same place. So can I include a FIND in the range selection? Also include something that looks for the last row of data?

That's close. The Grand Total column header is merged between H1:H2. Attached is a sample set.

So I've spent the better part of the day trying to learn and understand vba range select statements. I've attached a new sample report. This has 2 tabs. What my normal raw data looks like and what it looks like after I ran my macro with a hard coded Column F. Below is my entire CODE. Bernie's last update does sort of sort on the "Grand Total" column but doesn't move up the "Grand Total" row. This code was working well for me until a new column was inserted and it thew everything off. So I'm trying to adjust the code to be dynamic based on possible changes in the raw data.

Please Login or Register  to view this content.

Here is some code I found that I thought might help me, but I couldn't get it to work.

Please Login or Register  to view this content.

I'm also trying to learn from this, particularly the ability to select various ranges. Seems like a skill that will always be useful using vb macros, so I won't have to ask for everything and eventually be able to help others

I'll give that a try. The data is generated from the salesforce application, so I can't alter the design. At least not that I'm aware of at this time.

Thanks Bernie