Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a master sheet referenced to multiple worksheets
I currently have an Excel document with numerous records for various products
containing information regarding product type, model year, concern, failure mode, etc. Because each product is handled by a different person, I would like to split each product into a separate sheet but allow anyone to search for information based on any of the entered information on a 'master sheet'. Very similar to the way the 'AutoFilter' option works on individual sheets. The reason I would like to split the products is to give everyone their own sheet to update and not have data for products spread around a single sheet. Thus, if anyone has any input on how to create a master sheet with drop down lists created by all the informaiton on other sheets, that would be great. -- Thanks John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mutilpe sheet , multiple formula help please. | Excel Worksheet Functions | |||
Link Worksheets to a Master Sheet | Excel Worksheet Functions | |||
Functions across multiple worksheets | Excel Worksheet Functions | |||
Combining specific ranges from multiple worksheets into one | Excel Worksheet Functions | |||
Linking References from Multiple Sheets to One Summary Sheet | Setting up and Configuration of Excel |