Results 1 to 5 of 5

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

Threaded View

  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

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