Dear Home Ec 101,
Can you clarify your directions for making the shopping list from your Thanksgiving menu using a spreadsheet?
Confused in Conyers
Sure thing, a visual might help and keep in mind I was cooking for 20, before you freak out over 2lbs of butter.
Click the image for a bigger version.
At the top of each row is the name of the recipe. Since almost all of the recipes are available on this site, I have the recipe linked underneath. Otherwise I would just have them near me as I created the spreadsheet.
Below each recipe I list the ingredients (all of them, even salt, pepper etc)
Below the ingredient lists, I made headings of grocery store sections: Dry Goods, Produce, Butcher, etc.
Then I copied and pasted the ingredients from below each recipe heading into the appropriate grocery store section. I also indicated the quantity of the item when it was necessary: pounds of potatoes, bunches of celery etc.
When all was said and done, I copied and pasted the grocery store sections onto a new tab and printed.
I hope this clarifies things for you.
Send your questions to firstname.lastname@example.org.