Thanks for the input. I will give it a try. Am I limited to 125 entries?
Also, as data is entered into each of the attached sheets, will the filtered
list in the 'summ' sheet automatically update?
--
Thanks
John
"Max" wrote:
For a pure formulas-automated play which works to pull in and stack data from
up to 12 identically structured individual sheets (this would be your
individual product sheets) into a single summary/master sheet, try this
sample from my archives (nicely rendered, full details inside):
http://www.savefile.com/files/236284
Auto summarize n stack lines from 12 primary sheets.zip
The desired stacking sequence for data from the 12 individual sheets within
the summary sheet can be defined easily. Just ensure that the sheetnames
entered within the summary sheet's R5:AC5 are consistent with those on the
actual sheet tabs, ie match exactly, except for case.
Data will be stacked continuously, all neatly bunched at the top, w/o any
intervening blank rows. You could then apply autofilter on the stacked
summary table.
As-is, the sample construct caters for a max of 125 lines/rows expected per
indiv. sheet x 12 sheets = 1500 stacked rows (max) in the summary
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"John" wrote:
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