Results 1 to 6 of 6

Using Drop downs in creating an estimating worksheet.

Threaded View

  1. #1
    Registered User
    Join Date
    11-12-2018
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    5

    Using Drop downs in creating an estimating worksheet.

    Hi All,
    I am creating an estimating worksheet for calculating the cost to produce dimensional CNC router cut letters. I am a nube at Excel and I've been studying up on the basics. Jeff was a big help with the formula for counting text typed into a cell.
    To keep the user interface simple to use, I would like to use drop down lists to choose the options such as letter heights, substrates used to make the letters out of, and a number of others.
    I've attached a sample file that better explains what I'm trying to achieve. I've inserted some dropdown lists into some of the cells as well as some basic formulae where I could.
    At this point, I'm trying to combine an item from the drop down list with the cost per square foot for the material.
    Once I get past this hurdle, I will continue to add to the formulae with optional items and minimums.
    Let me know if you can help.
    I'm loving working in Excel!
    Duncan
    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 in creating a form with drop downs
    By nileshsompura in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2018, 06:53 AM
  2. [SOLVED] Help in creating multiple dependant drop downs
    By ahm3d in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-04-2016, 07:49 AM
  3. creating drop downs
    By ITFAQ in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-21-2015, 04:44 AM
  4. [SOLVED] Creating a Sales Order with Drop Downs
    By ExcelLover67 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-22-2014, 05:53 PM
  5. [SOLVED] Creating a chart from multiple drop downs.
    By KenFisher in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-05-2014, 01:48 PM
  6. Creating dependent drop downs
    By harrybelly in forum Excel General
    Replies: 2
    Last Post: 12-08-2011, 05:08 PM
  7. Lists/drop downs creating more than one sub list?
    By Zhola in forum Excel General
    Replies: 6
    Last Post: 10-31-2007, 01:12 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