See attached XLS file.
In the column "E" I have many values with different background colors.
I need a macro, to be activated by the button "Update", that copies these values of the column "E" and pastes them under the columns on the right depending on the background color (obviously cleaning the old data before doing it).
It must support an indefinite number of different colors and preserve the text color and format too.