Not sure how to accomplish the following:
I have a Bill of Materials that is organized by subsystems. Each part is categorized in a cell within each row (e.g. connectors, fasteners, sensors, etc.). I wish to pull from this sheet and sort by category, each on it's own tab, and sum up the number of parts. So, for the SAME connector appearing in 3 different subsystems (appearing in 3 separate rows), I wish to pull these into its own tab and sum them. I can sort on category first, then by unique mfger part number to group like things together. Not sure if standard array functions will enable this, and how to reference from one sheet (subsystems) into another sheet (category of interest) and NOT have mostly blank rows. I hope I have adequately characterized the problem.