Results 1 to 5 of 5

Shopping list macro help

Threaded View

  1. #1
    Registered User
    Join Date
    01-22-2018
    Location
    UK
    MS-Off Ver
    2016
    Posts
    5

    Shopping list macro help

    Hi everyone!

    I'm fairly new to macros and VBA - so please excuse any stupid questions - but I'm hoping you can help me out.

    I'm trying to create a macro which will add selected items to a shopping list. When I click the "+" icon next to the item I want that item to be added to the shopping list on a different sheet, on the line below whatever has previously been added.

    On the attached document please see the first and second sheets which demonstrate what I'm trying to do.

    If what I am asking for is an easy task for you, and you wantsomething a little more challenging to get stuck into I have also added sheets 3 and 4, which show how I would have the sheet running in a perfect world. The add symbol would open up a pop-up which would allow me to enter in the quantity and units required. Pressing the "Add" button would transfer all of this data into the shopping list.

    I don't know if this is something which is possible, and I would be very happy if it only worked as I suggested in the more simple format, but if you could manage to create the pop-up that would be amazing.

    Thank you for your time, it is greatly appreciated and I hope you are able to help.

    Many thanks!
    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. Making shopping list work for me
    By Dibble708 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-07-2017, 08:34 PM
  2. Create shopping list from drop down menu
    By paulahunter3 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-20-2017, 12:22 PM
  3. Shopping list creator
    By DrPips in forum Excel General
    Replies: 17
    Last Post: 09-23-2015, 10:39 AM
  4. Shopping List Calculator / Budgeting Spreadsheet
    By UTDating in forum Excel General
    Replies: 3
    Last Post: 07-09-2014, 09:02 PM
  5. Shopping list
    By Shawn1973 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2013, 07:48 PM
  6. Itemized shopping list
    By jerryjaysr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2007, 12:33 PM
  7. Excel Shopping List
    By robertguy in forum Excel General
    Replies: 1
    Last Post: 10-21-2005, 05:05 AM

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