Thanks for the reply. I did that. These are the stps i followed.
1. Selected all the ranger to be sorted.
2. Sorted the excel  sheet so that the blank rows  come all the way on the end.
3. i recorded that macro and saved it in my personal folder.
4. the code saved is as follows.

Range("A2:E2").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
Range("A2:E2992").Select
Selection.Sort Key1:=Range("A2"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
ActiveWindow.SmallScroll Down:=-543
ActiveWindow.ScrollRow = 2
Range("A3").Select
ActiveWindow.SmallScroll Down:=-3

5. after gettign done i stopped the macro recorder.

now my question  is if the number of rows keep on increasing, this macro wont run
the rows more than what this macro recorded. So how do i need to take care of
it.

secondly, i was thinking, whenever the mail file is update  is there a way that i
can save a copy of it automatically  at a different location, and then import
from that location. I need to do this is because of permissions.