Wanting to automatically generate a chart from sheet1 to sheet3 that sorts by group name AKA column 1 headings (EXAMPLE 1, EXAMPLE 2, EXTRA,) and organizes it by color green,blue,yellow, then red. *Notice* that color is based on Conditional Formatting tool and is order specific in order to give me the coloring scheme that is wanted. For now we will ignore sheet2. Thanks
Solved by B. B. in 21 mins