+ Reply to Thread
Results 1 to 5 of 5

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

  1. #1
    Registered User
    Join Date
    07-30-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    2

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

    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
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,634

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

    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?
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,634

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

    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
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    07-30-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    2

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

    Quote Originally Posted by humdingaling View Post
    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!

  5. #5
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,634

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

    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
    Last edited by humdingaling; 07-31-2013 at 09:11 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. need help with data summary based on a daily basis
    By randypang in forum Excel General
    Replies: 1
    Last Post: 04-26-2013, 11:45 PM
  2. [SOLVED] Caculate fuel consumption in datasheet with mutiple vehicles.
    By LouisH in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-03-2013, 04:30 AM
  3. How to Auto-Generate a duplicate tab on a daily basis
    By jpv5 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2012, 03:40 PM
  4. Replies: 7
    Last Post: 01-06-2010, 10:58 PM
  5. Changing Temporary Pages on a Daily Basis
    By judah in forum Excel General
    Replies: 0
    Last Post: 02-03-2009, 06:21 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1