Excel grocery list problem

Question

I need some assistance with Microsoft excel. Whether this needs any macro coding is up to the person whom provides the solution. The following are my requirements for the program:

Assume a grocery list program is to be written in Microsoft excel. The following must be bought at the store

FOOD TOILETRIES BEDROOM

spaghetti shaving cream television

mustard toilet paper VCR

Tomato sauce toothpaste T-Shirts (2 XL and 1 Large)

Soup (butter nut and mushroom)

Now the program I want developed must do the following. The user must enter the above mentioned groceries by using for example an input box. However FOOD is level 1 of the list similar when using Microsoft explorer with the plus sign next to it (Can one program excel to use the plus and minus signs to hide and view information?). When the items under FOOD is added the program must populate those items underneath the FOOD heading (like tree view). So somewhere in the program one must be able to specify which level the item is. You will also see that 2 types if soups must be bought and the same principal applies to this. Butter nut and mushroom will be level 3 underneath the level 2 item soup. The program must also be able to insert and delete new and old items respectively at specific places. For example assume Jam must be bought and it needs to be inserted between mustard and tomato sauce.

In a nut shell this is what I require. Can anybody assist me on a solution on how this can be done. I understand that the above mentioned example is simple but it will give me the stepping stone to complete the more complicated problem.

Thank you

Answer 1

Thank you very much for the quick reply ToneML. The grocery list is only an example and does not represent the real problem. Think of the grocery list as different requirement for a specific design. 

The list will be operated on a daily basis by different departments looking at the requirements to ensure the requirements are met. As time goes on new ideas will be identified and others found unwarranted therefore the list needs to have a add and remove function.

You asked the question why do you need it to work like that. Well that was identified as the method but if you have a more suitable solution please inform me as this will be most helpful.

Thank you

Answer 2

Here's an Excel Grocery List template http://www.practicalspreadsheets.com/Grocery-List-Template.html, but it does not function in the way you require.

Can you say more about how you expect the list to operate on a daily basis? Why do you need it to work like that?

If you want to print only the items you need to get on a particular trip, I'd suggest a complete list of all the things you might ever buy, then use the Show/Hide Row function to display the list of what you wish to print.