Home

DATA CONSOLIDATION

%3CLINGO-SUB%20id%3D%22lingo-sub-699897%22%20slang%3D%22en-US%22%3EDATA%20CONSOLIDATION%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-699897%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20would%20I%20consolidate%20conditioned%20cells%20from%20different%20tabs%20in%20the%20same%20worksheet.%26nbsp%3B%20Specifically%20would%20like%20to%20capture%26nbsp%3Bentire%20rows%20from%20multiple%20tabs%26nbsp%3Bbased%20on%20the%20color%20of%20a%20particular%20cell%20in%20that%20row.%26nbsp%3B%20This%20is%20a%20parts%20inventory%20workbook%26nbsp%3Bthat%20has%20the%20%22existing%20qt%20on%20hand%22%20cell%20change%20color%20when%20it%20is%20below%20the%20minimum%20qt%2C%20(a%20formatted%20cell).%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-699897%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Ricky-195
Occasional Visitor

How would I consolidate conditioned cells from different tabs in the same worksheet.  Specifically would like to capture entire rows from multiple tabs based on the color of a particular cell in that row.  This is a parts inventory workbook that has the "existing qt on hand" cell change color when it is below the minimum qt, (a formatted cell).