lockheed.kid
09-25-2010, 01:29 AM
From the data provided in the attached workbook (Test Macro Tables.xlsx) - sheet 1, I want to create a table displaying defect count by responsible person in sheet 2, and a defect count by responsible area in sheet 3 (example tables provided).
Note the column totals are in decreasing order as well as the row totals.
Also note that each week these tables need to be created, and may have different defects, responsible persons, and responsible areas in the sheet 1 data (over 100 possible defects and over 20 possible responsible areas in reality).
Any ideas?
Note the column totals are in decreasing order as well as the row totals.
Also note that each week these tables need to be created, and may have different defects, responsible persons, and responsible areas in the sheet 1 data (over 100 possible defects and over 20 possible responsible areas in reality).
Any ideas?