+ Reply to Thread
Results 1 to 2 of 2

Copy values if checkbox is checked

  1. #1
    Registered User
    Join Date
    10-20-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    0

    Question Copy values if checkbox is checked

    Hi everyone! I'm completely new here and was hoping for some help with the following:

    I'm trying to set up a grocery list in an effort to save some money and keep from buying food items I don't need (limited storage space in our kitchen). Basically what I'd like to do is have checkboxes of different dinners that we could make each week. And then somewhere else have all of the "ingredients" that I would need to make that dinner as well as the aisle that the food item is in (so I can sort the list and follow it in order as I walk through the store). If I check the box next to a certain dinner then all of the ingredients I need for that dinner will populate on the next sheet.

    For example:
    I check the box next to tacos on Sheet1 and when I look on Sheet2 I'll see the ingredients and aisle number

    Ground Beef 2
    Taco Seasoning 5
    Shredded Cheese 12
    Sour Cream 10
    Salsa 5
    Taco Shells 5

    I'm usually pretty good with looking Excel stuff up online and altering it to fit my purposes but this one is making me crazy! It seems like I should VBA but I really don't know a whole lot about that. Any ideas how I can make this work? Any help is appreciated!

    Grocery List.xlsx

  2. #2
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: Copy values if checkbox is checked

    See how you get on with the attached
    Attached Files Attached Files
    Last edited by WasWodge; 10-21-2012 at 04:00 AM.
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown

+ Reply to Thread

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