Command Button or VBA Code for ascending order of dates

[Scrapnforfun]

Hi,
I am trying to set up a command button to reorder the dates inputted in ascending order. I make the button and run a macro but when I hit the command button to run the macro, my header comes into play and it puts the dates above the header line.

Example:
Line 1 has a header for my table
Line 2 starts the information I need have in ascending order by date. Column B is the column date that I would like in ascending order.

When I plug in dummy numbers on Lines 2 and 3, etc., Lines 2 and 3 get put in ascending order by date but my header gets moved to line 3 (probably because it's not a number, I guess).

I have attached the worksheet, but I didn't put in my macro as I thought it may add more confusion. Can anyone help me with running a macro with the command button or using a VBA code with the command button.

I also have the workbook set up to hide the ribbon automatically upon opening. I need this setup still, so you will have to hit "ALT F8" for the ribbon to appear to work with.

Just a side note item that is bugging me is I have on Line 1 a line that extends along the whole workbook horizontally. I don't know how to get rid of this. It's probably something silly but I haven't figured out what it is. Ughh!

Thanks so much for your help.
Lin

[alansidman]

Here is some code to attach to a command button

Please Login or Register  to view this content.

[Scrapnforfun]

Thanks so much for this code. It WORKS! I had to take a day or two and work it out as I had two worksheets to apply it to. I'm sure you probably could have had another vba code to handle this but I wanted to work it out so hopefully I can learn more. I'm sort of new to this. I've been learning from forums and youtube myself. Thanks again!
Lin