Sorting Table By Two Criteria

[Big.Moe]

In my Excel sheet, I have several tabs that correspond to truck numbers. In those tabs, I enter all the info for our truck fleet and drivers. To track driver pay and expenses, I have created a "DRIVER PAY" tab that compiles the needed data. Unfortunately, the file is too big to upload into forum, so I made a quick mock-up of a screen grab of the "DRIVER PAY" tab for clarity (see below).

TRUCK SHEET.jpg

As pictured, I already created a data table that compiled all the tab data into one table. I also created a test table for one weekly pay period that also removes all the blank rows. Now, I'm trying to sort that table by date (col. S) and then by truck # (col. V) into my final weekly pay print out form (columns A thru O). Unfortunately, I'm stumped about how to do this. I looked at using VLOOKUP, but was unsuccessful.

Any help would be greatly appreciated.

Also, if anyone sees a way to simplify/streamline this process, I'm all ears. I'm self-taught and can be a bit of a clunky hack at times.

Thanks for reading my post.

EDIT: I managed to strip down the file to just a bare version of the "Driver PAY" tab.

[crazyforexcel]

Hi,

Can you save your workbook as a different version and only keep some of the data for presenting your question.

It always helps to attach a workbook and not an image so formulas can be tested.

Thanks

[Big.Moe]

Hi crazyeddie,

I went ahead and uploaded a very stripped down sample file (in original post).

Thanks for reading my post.

[crazyforexcel]

Hi Big.Moe,

I am working on a set up today. I am also interested in trucking for my next career so I could also benefit from this. Please give me some time.

Thanks,
crazyeddie

[Big.Moe]

Hey crazyeddie,

If there is a way to get you the full file (~10MB), I'm more than happy to send it to you. It's a beauty in its full complete state.

With all the regulations and IFTA road tax system, the whole tracking thing becomes quite the accounting challenge.

[crazyforexcel]

You could zip the file first which should help. Make sure there isn't any personal information though.

[Big.Moe]

Darn, the file is still ~3MB after zip process. Forum allows only 1 MB for uploads.

[crazyforexcel]

Hi Big.Moe are you still looking for help?

[crazyforexcel]

I don't yet know all of the factors but maybe this can be useful? I moved a few things around and of course I may be way off.

Let me know thanks

[Big.Moe]

Hi crazyeddie,

Thanks so much for sticking to it. I got everything worked-out except for the very last part which was sorting the final table into chronological weekly dates. In the end, having the trip dates not in chronological order in the weekly pay report is not a huge deal since it still tabulates each drivers weekly pay just fine.

I tried converting the final weekly data into a table and sorting it by date, but it would rearrange itself every time the sheet recalculated.

I'm sticking a fork in this one and calling it done for now. Maybe down the road, when I have more time, I'll revisit the whole sorting the table by date and truck number.

Thanks again.