To Automatically Sort data based on date

FORUM_D7.xlsHI

Please find attached. THis shows you how to get the date so the rest will be adjusting the INDEX functions column number for the rest

Do you understand the Sort function in Excel.

Highlight the range A19:J48
Click on Data--->Sort
Make sure that the box for contains header rows is unchecked
Click on Ascending
Click on the sort/ok button.

alan, i think that what he's after is retrieving the values based on the dates at the top of the other (non data) sheet.

I THINK :o)

nathansav--you may be right, but often it is not clear in the request. We'll find out when the OP responds.

Guys, i want this to be done automated. becoz these values are retrieved here in report format using index & match function. now i just want the output to be sorted date wise automatically.

Not sure what else you want as your explanation is not exactly specific and my crystal ball is broken.

Please Login or Register  to view this content.

Alan, let me be even more clear.. See i'm retrieving the leave data in the attached format from two worksheets which has leave credit input in one and leaves availed input in another. Using Index & Match i'm able to get those values pertaining to the respective employee when his/her Emp.no is entered in the report sheet.

And now my query,

is to automatically sort the retrieved value based on dates.

in simple, when an Emp.no is entered in the format attached it gives the values from mutiple worksheets as per the formulas. now those retrieved data should be sorted automatically.

pls suggest.

Since I have not presented you with what you are looking for, I clearly do not understand what you are asking. You have presented the same worksheet with the same explanation. This is often referred to as "Einsteins's Theory on Insanity." .ie. doing the same thing over and over again expecting different results. Since we are not of that ilk, I suggest you try presenting your explanation in a different manner with examples. I clearly don't understand what you want. Your file offers no clue except to sort the data which I have done but you want something else?

I apologize for that. think the attached will give u a clear picture.

Attached work book contains 3sheets

'Leave availed' : will have list of leaves availed by employees
'Leave Credit': will have list of leaves credited to each employees

the these datas are retrieved for an individual employee in a specific format in 3rd work sheet named as 'Emp Leave Card'

just by entering the Emp.no i'm able to get those values using INDEX & MATCH functions
(plx check the formulas for better understanding)

now i need ur help to sort the retrieved automatically based on dates. i.e whether its a leave credit or leave availed, the values retrieved to be automatically sorted.

Also suggest if there's any changes to made with the existing formulas in order to make my requirement simple.

Hope i'm clear atleast this time.

Please Login or Register  to view this content.

Open your VBE, Alt + F11
In the left window, select the sheet you are working in
In the right window a blank screen will open.

Copy Ben's code and paste it into the window on the right.

Close and Save the VBE