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