Closed Thread
Results 1 to 7 of 7

GOOGLE SHEETS: Creating an order sheet from a drop down menu

  1. #1
    Registered User
    Join Date
    04-09-2013
    Location
    High Wycombe
    MS-Off Ver
    Excel 2010
    Posts
    21

    GOOGLE SHEETS: Creating an order sheet from a drop down menu

    Hi all and hope you can help.

    I am trying to create an order template with the following headings

    ITEM - CATEGORY - COST - DISCOUNT - %

    I have a data sheet with the entire product(ITEM, CATEGORY, COST) list on sheet 2. I have also created a drop-down list with the ITEM name from the data sheet.

    My question is... when i selct an item from the drop down list. Can i create a button that adds the row from the data sheet to the client order populating ITEM, CATEGORY and COST?

    Thank you,
    Last edited by AliGW; 10-27-2017 at 05:38 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,843

    Re: Creating an order sheet from a drop down menu

    Yes, but you'll need a macro for this - I'll move the thread to the correct section.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    04-09-2013
    Location
    High Wycombe
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: Creating an order sheet from a drop down menu

    Thank you Ali. Was trying to do it in sheets (Not sure if that is a dirty word in here?!) and was hoping you could without Macros as I have no idea how to do it there.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,843

    Re: Creating an order sheet from a drop down menu

    Ah, OK - no, not a dirty word at all, but you ought to have mentioned that in your thread title. I'll move you to the other platforms section, as it will determine the help offered.

  5. #5
    Registered User
    Join Date
    04-09-2013
    Location
    High Wycombe
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: GOOGLE SHEETS: Creating an order sheet from a drop down menu

    Haha sorry Ali, pretty sure there is nothing more to mention that would incur another forum change. Only reason i didnt put sheets in before was that I imagined that the other platforms forum would have much smaller readership.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,843

    Re: GOOGLE SHEETS: Creating an order sheet from a drop down menu

    Possibly, although I suspect most people use the New Posts view. Anyway, the question is NOT an Excel question, so I'm afraid it would be misplaced in one of the Excel sections and readers would assume that you were wanting an Excel solution, which might lead to both confusion and a delay.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,843

    Re: GOOGLE SHEETS: Creating an order sheet from a drop down menu

    Closed in favour of this thread, as an Excel solution is now required: https://www.excelforum.com/excel-pro...rder-form.html

Closed Thread

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 drop down menu to select a sheet
    By digitised in forum Excel General
    Replies: 10
    Last Post: 01-25-2017, 10:03 AM
  2. Purchase Order Drop Down Menu with Images is it possible??
    By imjakegator in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-28-2015, 05:08 PM
  3. [SOLVED] Drop down menu for an inventory order form
    By deafdef in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-17-2014, 02:46 AM
  4. Replies: 1
    Last Post: 02-07-2013, 11:03 AM
  5. Creating a Drop Down Menu
    By JoeHan in forum Excel General
    Replies: 5
    Last Post: 11-29-2011, 11:29 AM
  6. Creating a Custom Drop Down Menu
    By CEC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2010, 02:10 PM
  7. Creating a drop down menu
    By djt in forum Excel General
    Replies: 3
    Last Post: 11-21-2009, 04:54 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