Results 1 to 2 of 2

Help with creating an invoice calculator with multiple drop down menus and functions

Threaded View

excerbated123 Help with creating an invoice... 02-03-2015, 01:16 AM
alansidman Re: Help with creating an... 02-03-2015, 01:34 AM
  1. #1
    Registered User
    Join Date
    01-28-2015
    Location
    murica
    MS-Off Ver
    2013
    Posts
    15

    Help with creating an invoice calculator with multiple drop down menus and functions

    Ok so I posted a thread earlier regarding this but it didn't seem like I was very clear in what I wanted to do so let's try again.

    Again, I'm pretty new at this and any help or direction is greatly appreciated.

    So here's what I'm trying to do.

    First you might wanna download my example file so you can follow along.

    Looking at sheet 1 we have our first drop down; "category" in A4. I want to select an option there (Either Underlayment, Edge/Valley metal, Flashing, found on sheet 2) and have the next drop down (B4) automatically populate with different line items associated with their respective categories.

    Take a look at sheet 2 and you'll know what I mean.

    That's the easy part. Here's where it gets tricky for me...

    After making a selection in the 2nd drop down I need a few different things to happen.

    Looking at sheet 1 now:

    1. Cell D4 needs to automatically fill in the Unit from its source (on sheet 2 E4)
    2. Cell E4 needs to fill in the unit price (from sheet2 F4)
    3. Cell F4 (Tax) needs to run a little equation. It needs to take the value from sheet 2 H4 multiplied by the tax rate (sheet 1 D1) times the entered quantity in sheet 1 C4
    4.Cell G4 (Total) also needs to run an equation. It needs to multiply the entered quantity in sheet 1 C4, by the unit price (E4) and then add the tax value in F4

    I need to be able to repeat this with all items and have each one show their different respective values.

    Here's the next part:
    I need to be able to start the process over in the row below for each different item that I have. I dont want to create a page full of menus. I want to be able to only show a menu when I need one. So if I enter 5 items, I only want 5 entries to show up, and it's blank if unused. Does that make sense?

    Please help!
    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. [SOLVED] Creating a Price calculator using drop down boxes for multiple BOM's
    By sjkoehl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-24-2014, 01:40 PM
  2. Creating multiple Drop downs menus that are variable
    By Arnoldtp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2012, 09:20 AM
  3. Creating A Report with 5 drop down menus
    By SakebR in forum Excel General
    Replies: 6
    Last Post: 01-27-2011, 12:04 PM
  4. Functions for Drop Down menus
    By Aeroica in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-22-2008, 02:40 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