Filling out a fuel log that on a daily basis for different vehicles

[BINARY1010]

Hello, Im kind of familiar with excel 2010 but there are just certain thing that are way above my limited experience and probably right up you guys’ alley. I would really appreciate any help on the matter as Im breaking my head trying to figure out if the following is possible… I have attached a sample workbook; I have a fuel log that needs to be filled out on a daily basis for different vehicles and consolidated at the end of each year. I was wondering if there is a way to simplify the imputing of gallons and amount for each different fleet vehicle each and every day by creating a fill sheet. I thought that I could make it simple by imputing the date, fleet vehicle and amount of fuel used on the fill sheet and have it auto populate on each sheet accordingly. I.E. if I were to input this on the fill sheet:
Date 01/01/13
Fleet AT-08
Gallons 12
Amount $43.00
Then it would automatically populate the respective cells on the January sheet with the information provided.
I tried using the IF and LOOKUP formulas but I’m honestly drawing a blank on this. Is something like this doable on excel, I was looking into a Macro but really thing that is just a matter of finding the right formulas.
Regards

[humdingaling]

as formula's will not "stick" data in place
ie if you fill in 1st of jan it may work but come next time to fill in 2nd of jan it will overwrite anything

you probably need some kind of coding behind it to update
Q:
if you fill in 1st and you decide to fill in 1st again for the same fleet
do you want to overwrite or add what is already in there?

[humdingaling]

see attached what i came up with

i used overwrite because its easier =)

not much in error checking at the moment

had to create data validation to only Fleet# that exist can be chosen
i put day numbers on top of the date in the months because/.....well working with actual dates in VBA is buggy given international/US standards etc etc

[BINARY1010]

as formula's will not "stick" data in place
ie if you fill in 1st of jan it may work but come next time to fill in 2nd of jan it will overwrite anything

you probably need some kind of coding behind it to update
Q:
if you fill in 1st and you decide to fill in 1st again for the same fleet
do you want to overwrite or add what is already in there?

Hey hum, it would add to whats there already there.
I just saw the attachment you came up with and its just what I was looking for.
Thank you!

[humdingaling]

here is the code behind it

Please Login or Register  to view this content.

i think i explained the extra bits i put on the sheet already

the code works on the months being in order
sheet 1 is your update sheet
sheet 2 being jan
sheet 3 being feb
etc
please keep this in mind when updating

also
hidden rows above the date (in the month sheets) with the date number are important helpers in the code

as mentioned previously
code works on overwriting whatever you have in the sheets already
no checking to see if blank is done

the Gallons cells actually does nothing in the code so you dont actually need to input it