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
Bookmarks