I want to copy same highlighted cells from one sheet to another ,for example sheet 1 contains a column with different highlighted colours now i want that i can paste red highlighted cells in sheet 2, ,yellow in sheet 3 and so on.. ,in minimum time.
It would take you longer to engineer a solution (based on color) than it would if you were to manually cut and paste. Have you recorded a macro to perform your function, and tried to look at the code?
