Advice on Shopping List Spreadsheet

[MaryPoppins]

Hi, I am fairly new to excel but really want to learn to make some useful personal spreadsheets. One of the spreadsheets I would like to make is a shopping list and would like some advice on the best way to do this.

I think I would like to have 4 work sheets. 1 would be a database containing information about each item on the shopping list. The columns would be something like this -

Item Number | Item Name | Weekly / Non Weekly | Aldi / Asda | Category

001 | Tuna | Non Weekly | Aldi | Tinned
002 | Sour Cream | Non Weekly | Asda | Dairy
003 | Bread | Weekly | Aldi | Bakery

I would then like a worksheet that would allow me to easily input new items into the database.

Then I would like a worksheet that will nicely display an overview of each item under each category. Maybe with tick boxes next to each item that would then carry over to the final worksheet of a weekly shopping list.

The final weekly shopping list would display all the ticked items. 1 list would be for Aldi, the other list would be for Asda and each item would be listed under the certain category.

I'd basically just like to know if this is a good way of doing this? And what kind of formulas I will have to use to achieve this. I guess I will be using VLookup, and IF statements etc. I am a novice on excel but want to teach myself, so if you could point to any learning materials that would be great.


Thanks a lot,
Poppins

 

[SQUIDD]

Hi Poppins

Personally, I would have a main sheet as you describe, then have userforms to
1, add future items to you main sheet.
2, build you shopping list from combo boxes.

Finally your second userform would populate your shopping list on on a second sheet.

Quite a bit of work but would end up quite neat and professional looking.

Dave

 

[SQUIDD]

am happy to help you with this BTW.

Dave