Weekly Meal Planner Template Edits

**altj** · 10-24-2018, 07:01 AM

Hi all. I am trying to use the Microsoft Office Excel Template called "Weekly-Meal-Planner-TM16400504" (I'm not yet allowed to post URLs so please Google this. I appreciate your help!)

I want to include more than 7 meals in the list on the Meal Planner worksheet and still have the ingredients auto-populate into the Shopping List worksheet. I don't care if the columns are longer, or if there are additional columns (the idea here being I can include an entree, sides, and breakfast item for each day).

I have a small amount of experience using macros in Access but never used them in Excel before, and I have zero experience with Add-ins. That said, I don't see any macros or add-ins being used in this template, but maybe I'm looking in the wrong spot. I don't know how most of the formatting on this template is done.

I have a Mac, but if you only know how to fix this on a PC, tell me, and I can probably figure out the rest.

Thank you for anyone who can help me!

**AliGW** · 10-24-2018, 07:03 AM

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

**altj** · 10-24-2018, 06:40 PM

Thank you! Let me try to attach it now.

**altj** · 10-24-2018, 07:08 PM

I am now certain that the answer lies in the two functions being used in the Shopping List worksheet, but the functions are too complex for me. I'm trying.