| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting data from multiple worksheets into a master sheet/tab
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a summary sheet from data across multiple worksheets | Excel Discussion (Misc queries) | |||
| Sorting Data From One Column into Multiple Columns | Excel Worksheet Functions | |||
| sort data on multiple worksheets | Excel Discussion (Misc queries) | |||
| Putting data from multiple worksheets into one | Excel Discussion (Misc queries) | |||
| use data on master worksheet for sorting | New Users to Excel | |||
Threaded Mode
