VBA To look for dynamic column header and sort largest to smallest

[chhiew]

In row 1, I have a dynamic column with date (eg. from 1st to 31st) with daily sales data, at the end of column there is a header column "Grand Total", I want to write a script to look for "Grand Total" and do a autofilter or sorting from largest to smallest, below is the code i am working so far with no luck except i got to input manually range.("g1:g5000"), but like i said it's dynamic column the "grand total" column will change everyday, can anyone enlighten me, your help is greatly appreciated, thanks.

Please Login or Register  to view this content.

[bakerman2]

How about this.

Please Login or Register  to view this content.

[chhiew]

Bakerman2,
Wow your code is working, short and simple, thank you & you're awesome!

[bakerman2]

You're welcome and thanks for feedback.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[chhiew]

Done, Thanks again Bakerman2!

[bakerman2]

You're welcome and thanks for rep+.