Hello All, I would be grateful for any help with this.

I have a data range from AG72 to BD103 where row 72 is the header.
The range is cumulative, and calculates the results from another par
of the spreadsheet on a monthly basis, ie: AG is Apr-03 and BD wil
contain Mar-05 (when it arrives)

What I would like to do is create a VBA macro that sorts the data b
the values in the most recent month. I would call this from cell BG7
by selecting from a validation drop-down list of months.

Is this macro possible? and if so how ?

Also, is it possible to have a second macro that would resort the dat
alphabetically by the row contents in each row of column AG.

Hope this makes sense, and I look forward to your replies.
Thanks
Scott

--
scottwilson
-----------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...fo&userid=1112
View this thread: http://www.excelforum.com/showthread.php?threadid=26603