Sales names are H2:H6 on sheet1.
When i say ALL and run the macro now. it should show all data for each color ignoring the salesmen. It looks now like its repeating.