Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Getting 1 list from 2 sheets
Hi y'all,
I'm getting ready to tackle a project that I've been wanting to do for months. Basically, I've got a master list of about 300 types of groceries, all separated into categories and sub-categories (breakfast/cereals, veggies/green beans, etc.). On another tab is my master list of coupons that we have available. And on the 3rd tab is where I want the magic to happen. When I click the little item checkbox on the Master list tab I want that item to insert itself into the Shopping List tab. Once the checkbox item is entered, I want Shopping List to scan Coupons and if there are any coupons for anything in that sub-category (category breakfast/sub-cat cereals) then auto-populate the coupon info so that I know exactly what to get. So, how do I make oncheck (?) auto-populate into another sheet, then scan and insert more info if it's there? There's still alot more that I want done with this thing, but I know that those auto-inserts are paramount, so I better make sure that's possible first, before building everything else around it. I look forward to your replies, and thank you --- as always!! ~Ky Last edited by txheart : July 5th 11 at 04:01 PM Reason: clarity |
#2
|
|||
|
|||
This sounds like a fun project! Can you attach a sample spreadsheet and I'll give it a go. Doesn't sound too difficult, but makes it more difficult to start from scratch.
|
#3
|
|||
|
|||
In anticipation of you attaching a sample spready, I have come up with a couple of options.
Basically these both do the same thing, however:
Let me know if I'm on the right track here. |
#4
|
|||
|
|||
Tarquinious - thank you for your reply. I havent looked at your attachments yet, I wanted to get what I'm working with uploaded for you. Keep in mind that this is the start of this project. Pretty much anything can still change at this point, but this is what I've got so far. I'll go have a looksee at your now. Once you've had a chance to look at my attached I'd appreciate your input. Thanks again!
~Ky Last edited by txheart : July 6th 11 at 05:45 PM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate sheets list | Excel Discussion (Misc queries) | |||
Top 20 list from multiple sheets | Excel Discussion (Misc queries) | |||
List Sheets excluding sheets named ***-A | Excel Discussion (Misc queries) | |||
Creating Sheets from a List | Excel Discussion (Misc queries) | |||
list of sheets | Excel Worksheet Functions |