I have been doing this for a few months now and have been sorting each vehicle separately and now, after spending 5 hours a month on this SS I was wondering if I can sort each vehicle by date at the same time.
So ... can I prompt excel to sort by date, per vehicle (while expanding the selection to include all of the data?)?
My Columns are:
Vehicle ID/Vehicle #/Trans Date/Days Between Fill/Odomoter/Mileage per tank/Product/PPG/Net Fuel/MPG/$CPM
And I would like to set excel up so that it sorts transactions by date for that vehicle only.
It was okay to do this manually (sort ascending, per vehicle) for the first few months, but now, doing this every single month for 41 vehicles is growing old. Does this have to be done manually (one vehicle at a time)?
Edited by Serenity Now, 26 April 2006 - 11:21 AM.