Hi Ty,

Am Thu, 10 Dec 2015 19:59:56 -0800 (PST) schrieb Ty:

One special sheet with numbers of what you just completed for me along with:
-Display will change based on the filter and number from what was solved with color counting
-Display the label of the column in A4 or somewhere
-Display the row names(xyz_01)
-Display the numbers from the color counting(bottom on row 200-205? column K-S?) next to the row name(xyz_01)

Sheet for each color:
-Display just the label of the column
-Display just numbers of what was solved with the color counting
-Like a snapshot after the filter is set

can you filter your table by color and copy & paste the filtered range?
If not, please provide your workbook with an example of an expected new
sheet.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional