Auto Insert info based on another tab

[kylee]

Hi y'all,
I'm taking on a largish project that I've actually wanted to do for quite some time now. I finally got a good home computer and I'm ready to dive in! I'm not sure how to do the auto stuff though, which is hopefully where your help comes in.

Scenario:
One workbook with 3 tabs: Tab1 is Master List, Tab2 is Shopping List, Tab3 is Coupons. Master List is just a list of one word/phrase items (ie bread, cereal, orange juice, etc.); Coupons is the specific detail of every coupon I have; Shopping List is where I want the magic to happen.

When I click a checkmark on the Master List page (basically, I'm choosing something that I want to add to the shopping list) I'd like the item to auto-insert itself into the next open row on Shopping List. Once the auto insert is done, I'd like that item's sub-category (cereal, orange juice, etc.) to be searched for in Coupons to see if there are any coupons listed in that category. If a coupon exists for that sub-category, I'd like it to copy itself into Shopping List.

So, if a coupon does NOT exist, Shopping List would just show basic item I need - i.e. Cereal, Orange Juice. If a coupon DOES exist, the basic info would be there, but next to that (see wkbk on GoogleDocs) the coupon info listed on the Coupon tab would be copied and pasted into the Shopping List coupon section. Hmmm, I just thought of a hurdle ... sometimes I have more than 1 coupon within a sub-cat, do you have any suggestions how I could handle that?

I've looked and looked and looked for something like this available online, but I can't find anything even close. Shoot, if I'd come here back when I first started looking I'd probably be finished now! I look forward to your replies, and thank you in advance!!

~Ky

P.S. - This was posted on ExcelBanter yesterday but only one person replied, and it took a day for that to happen, so I came here hoping for y'all.