Multiple page list filtering

[freeon]

I'm new to this forum but not new to excel. However I'm not an expert either. Here is what I would be able to accomplish. I’d like to create a workbook that would contain 5 work sheets. The first worksheet would contain a list of items approximately 100. I would like to be able to choose specific items from the list on the first worksheet. After these items are chosen they would appear in a list on the other pages in the workbook. The thing is that some items would need to appear in 1 list and some would appear in multiple lists. Each item would always appear on the same lists. Example: if I determine that each time item 1 is chosen on the main list it would appear on page 2 and 5 it would be the same for every time item 1 is chosen. It’s a little hard to explain so I hope you understand what I’m saying. I would post an example but don’t have anything done yet. If there is any more information I can give let me know.

[arlu1201]

Can you please explain with the help of a sample file?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[freeon]

I have attached a sample file. This is just a generic one. The final one will have a longer master list and more worksheets. If you have additional questions let me know.