Hey Gang,
I see the end result and have an idea how I want to get there but there are variables testing me above my pay grade.
I am working in 2007
In Book 1, I have 30 Drivers/Tabs each Driver/Tab is broken into 6 sections which has several rows where we input their Jobs which determines their payroll.
Also in each section we have cells earmarked for the Truck Number, Gallon Cost, Total Fuel, Total Fuel Cost
6-11-2013 8-48-30 PM.png
Once we have input this info for each driver we then have to have to take the stack of gas receipts open Book 2 and input all that info again the data sort the receipts by truck number and input each one under the specific truck number.
6-11-2013 8-53-08 PM.png
Here is the catch I have 5 trucks that we don't want that information. Those 5 trucks never change, however the one that we do need to input this for can change due to rentals.
(this is double work)
End result is I want to create a mileage tab in Book 1 and as we key in the truck#, Gallons, etc the mileage tab would
1st determine if the truck number is one of the ones we ignore or not.
2nd if it is one of the trucks we need that info it would carry the respective info over to the correct cell.
I have enclosed 2 png's to provide some type of visual
Thanks in advance for any help.
Bookmarks