Results 1 to 5 of 5

How to multiply drop down menu times product price on sales sheet

Threaded View

Jimbobslob How to multiply drop down... 07-11-2012, 03:47 PM
oeldere Re: How to multiply drop down... 07-11-2012, 04:03 PM
K m Re: How to multiply drop down... 07-11-2012, 04:04 PM
Jimbobslob Re: How to multiply drop down... 07-11-2012, 04:09 PM
K m Re: How to multiply drop down... 07-11-2012, 04:31 PM
  1. #1
    Registered User
    Join Date
    07-11-2012
    Location
    Birmingham, AL
    MS-Off Ver
    Excel 2010
    Posts
    2

    How to multiply drop down menu times product price on sales sheet

    I'm not advanced at all in VBA, or Macros for that matter, and may need this explained to me like a 5 year old, if possible.

    I am creating a sales sheet to send to customers, that can be filled out by them and have the total calculated. I have attached what I am thinking for the spreadsheet. However, I don't even know how to populate the drop down menu.

    We sell our products wholesale in multiples of 20. I need to know how I can have the drop down menu options be '20, 40, 60, 80, & 100', which then multiply by our $3.50 cost, at which point can have the $5.00 added whether or not the display option is chosen..displaying the total amount in the far right column.

    I hope this is not too confusing..please let me know if it is so that I can better explain. Thank you for any and all help offered.
    Attached Files Attached Files

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