Macro to sort rows by date which appears in Column (B)

**Tmc2159** · 06-06-2013, 06:29 PM

Hi all

I don't know much about excel just attempting to make my job a little easier by not having to read 1000 lines of code a day.

I am attempting to do this to keep track of my small business finances.

I have a date and time in column (B) of my excel spreadsheet.

I need the rows to sort according to time and date and keep the content of the row.

Meaning that row (2) which is 2, 2/18/13 23:06, blue.... should stay together just be moved up or down according to its date.

I know very little about macro and coding so any help would be appreciated.

Thanks everyone

PS: I am new to this forum thing, so I don't know if this will actually help me in any way.

Note that I attached a sample file at the bottom of my post.

Any help is greatly appreciated.

Have a safe day.

**tigeravatar** · 06-06-2013, 06:40 PM

Tmc2159,

I don't think this requires a macro, just the built-in Sort feature should suffice. I just selected the your data and went to the Data tab and clicked on Sort, checked "My data has headers" and told it sort by "Sand" (column B) ascending (oldest to newest), and it worked just fine for me. Does it do something unexpected for you?

**tigeravatar** · 06-06-2013, 06:44 PM

If you need it to be a macro, something like this should work for you:

Please Login or Register  to view this content.

**MarvinP** · 06-06-2013, 06:45 PM

Hi TMC,

You really don't need a macro to do what you want. You DO need to put names in the cells on the 1st row. Then your data can be treated as a TABLE. Once in a table you can simply click on the data tab and sort it by column B.

See http://www.gcflearnfree.org/excel2010/11.2 for some examples.

**Tmc2159** · 06-06-2013, 07:06 PM

Thanks so much tigeravatar.

One quick, question: How does your macro know to sort according to Column B.

Would this work if I had timestamps in both A and B.

Thank you so much for your help

**tigeravatar** · 06-07-2013, 10:27 AM

The macro is working on the used range of the sheet, which means from the top-left most populated cell to the bottom-right most populated cell. The .offset(, 1) tells the code to use the column 1 to the right, and the resize(, 1) tells the code to use only that column, which is how it knows to use column as the key column for sorting. And yes, it would still sort by column B even if you had timestamps in column A also.