Automatic copy paste

Closed
ayesha6 Posts 2 Registration date Thursday January 5, 2017 Status Member Last seen January 5, 2017 - Jan 5, 2017 at 06:27 AM
 Blocked Profile - Jan 5, 2017 at 05:26 PM
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.

1 reply

Blocked Profile
Jan 5, 2017 at 05:26 PM
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?
0