+ Reply to Thread
Results 1 to 2 of 2

Autofill cell based on drop-down selection

  1. #1
    Registered User
    Join Date
    10-06-2012
    Location
    Stockbridge, MA
    MS-Off Ver
    Excel 2008
    Posts
    1

    Autofill cell based on drop-down selection

    As a disclaimer, I'm an amateur excel user.

    I'm trying to create a spreadsheet that helps manage my printing jobs by doing the following:
    Based on paper selection (c2), determines square feet (E2) (autofilled based on selection) as well as cost per sheet of paper (D2) (autofilled based on selection) .

    Then based on DPI (dots per inch) selected (F2), determines amount (G2) and cost of ink used (H2).

    When DPI (F2) is selected, Ink Use (G2) (total mL used) is autofilled in ((mL of ink used per square feet at the selected dpi (data lives on sheet2, b30:b32)) x (square feet of paper (E2) that was already determined)) and then cost of ink (H2) also autofills in ((cost of ink per mL used (data lives on sheet 2, (c30:c32)) x (total mL of ink used, G2)).

    Finally, cost of ink (H2) + price per sheet of paper (D2) will be added together to give the total print job cost estimate (I2).

    (Sorry if I'm using laymen's terms or being confusing.)

    I'm attaching my spreadsheet and all of the data lives on sheet 2. I had to copy some lists onto sheet1 because the drop downs couldn't be created with lists from a different spreadsheet.

    Basically, I'm trying to figure out how to make the above mentioned autofills happen.

    Thanks so much!
    Attached Files Attached Files

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Autofill cell based on drop-down selection

    It would be good if you could manually fill in a few examples of the numbers that you expect to get so that it is possible to check these against the results of any formulae used.

    It is possible to have the values for drop downs located on a different sheet by sheet by using named ranges. I guess that ideally you would want the workbook to be able to cope with the addition or removal of entries in lists such as the paper type.
    Martin

+ 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