Sort rows in a workbook based on Date in Row A

[michelle 1]

This sounds very simple, however i have searched many forums and tried various codes but without sucess, my data spreads from Columns A to R and starts in row 4.

Would be grateful if someone could help me with the code to sort the data by column A

many thanks

[Debraj Roy]

Hi michelle..

below is just a recorded macro.. check this..

Please Login or Register  to view this content.

[michelle 1]

Thanks Debraj for your prompt response. Does this mean i need a button as i was hoping for it to apply automatically upon opening.

[Debraj Roy]

OK.. You want this automatically upon opening .. then..

in ThisWorkbook Section.. in Workbook_Open() use below code..

Please Login or Register  to view this content.

[michelle 1]

Hi Debraj, i am receiving a Runtime error 9 subscript out of range, any ideas?

[ankitparate]

Try this,

Please Login or Register  to view this content.

[michelle 1]

Hi thanks for responding.

I was googling this as we speak without any luck, I Assume I need to change "Partial Shifts" and "Day off Trades" are these the tab names? I have 12 tabs - January to February. Appologies for asking a silly question but i am new to this. My Worksheet is called Events Spreadsheet.

Really appreciate your help.

[ankitparate]

Please Login or Register  to view this content.

[michelle 1]

Thank you so much, i have my header in Row 3 and it is placing the data above this, what part of the code do i need to ammend? really really appreciate your help.

[michelle 1]

Would you mind checking my code, i guessed based on what you gave me. It actually works fine, however i get an error message saying excel found unreadable content this appeared after i entered the code, if i click on yes this is from a trusted source its fine and sorts perfectly but obviously i have done something wrong?!

Please Login or Register  to view this content.

[ankitparate]

if you want to add worksheet automatically then use this code

Please Login or Register  to view this content.

[michelle 1]

Hi thanks again for replying.

I am really sorry to ask but where do i insert the code and what part of my code do i need to remove, i really am very new to this and willing to learn.

[ankitparate]

You don't need to declare 12 object for 12 months saperately you just add the above code that I given to you that add worksheet automatically to your workbook.
That code you have to place within the loop.

Look at this sample code:

Please Login or Register  to view this content.

I hope you understand.

[michelle 1]

Hi, as i said i am a real newbie i cant read the code but i have been playing around wth it for an hour and a half. I have the following, i have been adapting your code to the sample code, am i on the right tracks??

Please Login or Register  to view this content.

I think i need settig straight with what i have and then i will have another go, i am self teaching so do not understand the terminology of the code.

Thansk for helping me get my head round it. (Sorry reposted with code tags and not HTML!)

[ankitparate]

you done wrong man.

I attached image with this post.

check it.

code.JPG

[michelle 1]

Thanks for your reply and the code explanation. My code knowledge is very basic and therfore i am unable to interpret the information you are giving me. Im not sure what i need to change/add on your sample. I will have to leave it and manually sort my data on each tab as i really do not understand how to write it from what you have provided.

Thanks for your patience.

[ankitparate]

I send you the sample code. check this.

run this code and see the output.

[michelle 1]

I have done it i fiddled around with what i was doing and it works, admittedly its probably not pretty but it does the job. Thansk so much for your patience and help.

Please Login or Register  to view this content.

[ankitparate]

Anytime.

If you want more help then ask me