+ Reply to Thread
Results 1 to 7 of 7

Create pick-list from a master list

  1. #1
    Registered User
    Join Date
    05-31-2014
    Posts
    29

    Create pick-list from a master list

    Hi

    not sure if this is the correct forum for this question

    My grandson has the project of creating a spreadsheet for a real life purpose.

    He created a shopping list based on the floor plan of the supermarket and everything in my cupboard.

    So one column contains the 300 or so items we might buy

    What he wants is to be able to mark the second column with ticks to indicate the items required this week

    Finaly he wants to export the ricked items to the printer

    Is this possible in excel?

    I'd use a database myself but what teacher says,,,,

    thanks

    Ian
    Last edited by FDibbins; 05-31-2014 at 03:35 PM.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: shopping list

    Suggest adding tick or other character to second column. Then use auto-filter to just select the rows with the ticks and finally print.
    Martin

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: shopping list

    Hi and welcome to the forum

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?).

    I have changed it for you - this time
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: shopping list

    Nice project :-)
    Guess this can well be done in Excel
    On a sheet you can easily draw a floorplan. Clicking on section could bring up a list articles in that section.
    You than could select articles from that list. The selected articles can be inserted to a textbox (or removed again).
    When finished you could print the textbox or what you like to do with it.
    Are there any constraints to the project? Will vba be allowed?
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Create pick-list from a master list

    It isn't difficult to set up with checkboxes that are linked to cells. The selected items are then filtered and printed.

    The organization of course is at the mercy of the store. They shift things around a lot just to make you look all over the place for items. Organize by item type rather than location in the store. ....produce, meat, eggs, canned goods, baking supplies etc.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  6. #6
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Create pick-list from a master list

    Here's how I would do it...

    Let's assume your current list is in the range A2:A300.

    I would use an event macro to enter an X in the corresponding cell in column B when you double click on the cell. For example, A10 = Carrots, double click cell B10 and an X gets entered in the cell. You can even write the macro to remove the X on subsequent double clicks if you change your mind.

    Then, I would add a button on the sheet and when you click the button a macro would execute a print operation of the items marked with the X.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  7. #7
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: Create pick-list from a master list

    Hi jenOdorf,

    Or you could use a simple filter.
    Place a Y (yes) against the items required.
    Use the filtyer to just show the rows with a Y
    Please see attached.

    Regards

    peterrc
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Shopping list creator
    By DrPips in forum Excel General
    Replies: 17
    Last Post: 09-23-2015, 10:39 AM
  2. Shopping list
    By Shawn1973 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2013, 07:48 PM
  3. how to create shopping list from menu options?
    By mchorley in forum Excel General
    Replies: 7
    Last Post: 03-07-2012, 07:08 PM
  4. Itemized shopping list
    By jerryjaysr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2007, 12:33 PM
  5. 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