menu plans /shopping list help -open office

miaoww

Hi, have created a meal list and wanted to create menu plan and shopping lists from this using spread sheet from open office - have viewed simular ones from here but wanted to try and do my own.
have listed the meals in column a and indredients in the other colums but have no idea on how to create a shopping list and menu plan from this. can anyone help please.

Ches

Bumping this as I would like to know too.

wssla00

I would have more columns. I would have perhaps day, meal type, ingredients, name of meal, week number etc etc then you can add filters (autofilter) and you can filter them down e.g. each day/week/month, type of meal, etc.

Then you can filter to week number which will give you the meals for that week, then highlight the list of meals and days set the print area as that only and print out the whole sheet on one page.

For the shopping list, you can add another column of ingredient needs to be bought? with the answer being yes or no and then filter both the week number and whether you need to buy the ingredient to only show yes then only print the ingredients column by again setting the print area.

I know there will be fancier ways of doing it but that's the way I do it.

miaoww

thanks will try and figure it out - only have very basic knowledge of spreadsheets (and i mean basic) managed to copy and paste one from another link but as its a different version i can print out a shopping lis - gutter so will try and figure out the original one
any more pointers would be welcome

Pink.

Hi miaoww,

As you haven't had many replies on the Old Style board I've moved your thread over to the techie board to see if you can get some more advice.

Hi, Martin’s asked me to post this in these circumstances: I’ve asked Board Guides to move threads if they’ll receive a better response elsewhere(please see this rule) so this post/thread has been moved to another board, where it should get more replies. If you have any questions about this policy please email [EMAIL="abuse@moneysavingexpert.com"]abuse@moneysavingexpert.com[/EMAIL].