Having Secondary Worksheets Pull From A Master Worksheet

**bluetea.55z** · 08-16-2010, 09:23 AM

I am creating a simple Inventory Database for a Restaurant in Excel 2003. I attached the .XLS file that I am using to give a better idea of how I want this to work.

Very simple, I have one huge worksheet called "Master List" which only has one important column in it "Product." Within the "Product" Column is a huge list with all of the products that the restaurant orders. You can disregard all of the other columns as they will be filled out by hand.

I also have 14 other Sub Worksheets labeled Pastas, Pizza, Dry Goods,Produce, Spices etc. I want to make it so when I add a new item to the "Master List" it will also go to the Sub Worksheet that it belongs to.

I'm assuming the best way to do this would be to create another column on my "Master List" Worksheet called "Category." Within this column it will specify for each inventory item the category that it belongs. (ex. Pastas, Pizza, Dry Goods,Produce, Spices). I don't know if this will involve some code or what, but I'm assuming that it can't be too hard. If someone wants to take my idea and explain how to do this or come up with a completely new system for me I would greatly appreciate it.

thank you,

Jack

**royUK** · 08-16-2010, 09:25 AM

The best way to handle data like this is to maintain the master Sheet & use AutoFilter by including a category column. Much easier to manage than individual sheets

**bluetea.55z** · 08-16-2010, 09:46 AM

Yeh, the only problem with this is that these sheets are going to be printed and in the restaurant they want it organized in different categories. So it has to be printed in a way where each item is within the category it's supposed to be in for the restaurant also. Is this still possible with the filter? Could I maybe filter first, then print and just label each list with a pen?