+ Reply to Thread
Results 1 to 2 of 2

Auto Populate Two Columns Based On Data Entered Into Another Column

  1. #1
    Registered User
    Join Date
    03-11-2013
    Location
    bridgetown, Barbados
    MS-Off Ver
    Excel 2003
    Posts
    1

    Auto Populate Two Columns Based On Data Entered Into Another Column

    Hi everyone, I'm new here and need your assistance. I have two dilemnas
    1. I am entering billing data to calculate a vessel's time alongside a pier and the rates to be charged are based on that vessel's GRT (gross Tonnage) and LOA (Lenght Overall). Using excel 2010, my workbook has two sheets (see attched). Sheet one is where i enter the information to generate the billing charges, Sheet two has all the drop lists for which sheet one info is selected.

    I would like that whenever i select a vessel's name, it's corresponding GRT and LOA cells will auto populate .

    2. The columns From date/Time and To date/Time are set to automatically calculate the total hrs to be billed but i must have a default date and time as shown, i'd rather the formula be hidden and the two columns remain blank until i enter data into them which will automatically calculate the billing hrs.

    i hope someone can help me as it mayl take a full eight months before my company can get the programmer to write a programme for this type of service and having to input all these data everyday is slowing us up.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    03-12-2013
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2007
    Posts
    230

    Re: Auto Populate Two Columns Based On Data Entered Into Another Column

    Here you go.

    I attached the workbook, but the formula is just an IF and a VLOOKUP.

    Start it off by saying =IF(A3="","",vlookup(....)
    This returns a blank cell if the cell in column A is empty.

    Finish the formula off by using a vlookup to look up the value on the second worksheet.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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