IgnBan
04-04-2008, 06:40 AM
I got a data table that I need to code a filter to show the results in another sheet in the same workbook in a drill down methodology to come up with a top 5 most repetitive entries.
The table consists of quality demerit from a production line and the descriptions of these are base on a predefined syntax. Each word of the sentence is storage in a separate cell (5) that at the end of the week are move and storage in an Access Db to query for future reports, but during the week are use in several different reports, like the intended analysis post here..
In sheet ?ERRORS? I need to filter the top5 most repetitive for the week and current day, but only taking in consideration the three first columns content (a cell may contain 2 words) and show the results in sheet ?FINAL? in a descending format
I have built a Pivot table to replicate what I need, but I need to do several more reports this way and I need and idea how to start.
The reason I don?t want to use the pivot tables is to ?control? the workbook in a better way. Before the workbook is released to the floor I will put passwords to protect cells, ranges, sheets, I can also hide sheets (pivot table), but I have to give the password to supervisors because I don?t want to have a call every time they make a small mistake in a protected cell. So my intent is to give password of workbook sheets but not code. The pivot tables are very easy to mess up the top 5 if unprotected someone moves one of the fields.
Thanks in advance for any replays :thumb , and I hope everybody is doing fine with no withdraw symptoms from the site been down last week, I contra arrested my by doing something productive; mowing my lawn! Yes is that time of the year here in the States agghh !
Attached WB
The table consists of quality demerit from a production line and the descriptions of these are base on a predefined syntax. Each word of the sentence is storage in a separate cell (5) that at the end of the week are move and storage in an Access Db to query for future reports, but during the week are use in several different reports, like the intended analysis post here..
In sheet ?ERRORS? I need to filter the top5 most repetitive for the week and current day, but only taking in consideration the three first columns content (a cell may contain 2 words) and show the results in sheet ?FINAL? in a descending format
I have built a Pivot table to replicate what I need, but I need to do several more reports this way and I need and idea how to start.
The reason I don?t want to use the pivot tables is to ?control? the workbook in a better way. Before the workbook is released to the floor I will put passwords to protect cells, ranges, sheets, I can also hide sheets (pivot table), but I have to give the password to supervisors because I don?t want to have a call every time they make a small mistake in a protected cell. So my intent is to give password of workbook sheets but not code. The pivot tables are very easy to mess up the top 5 if unprotected someone moves one of the fields.
Thanks in advance for any replays :thumb , and I hope everybody is doing fine with no withdraw symptoms from the site been down last week, I contra arrested my by doing something productive; mowing my lawn! Yes is that time of the year here in the States agghh !
Attached WB