Linking information between sheets

Originally Posted by annaengr

I have created a filing index for work that is used to track emails that have been sent to the project. The system is broken down into about 15 categories with several subcategories following. All 15 categories are entered on one worksheet in excel. I would like to link each category to a different page so that there is one giant page with all of the emails that is updated and then there are 15 extra sheets that show each category with the relavant subcategories that updates automatically. Is there a way to do this?

Hi,

Hopefully the item "Worksheets in VBA Coding and in Worksheet Formulas" at http://www.mvps.org/dmcritchie/excel/sheets.htm will provide some help to you.

---