PDA

View Full Version : Copy Data from one sheet to another IF cells are specific text colour



alecjhewitt
05-01-2018, 03:05 AM
Hello All,

I am looking for a macro that will copy across cells with certain text colour into from a main sheet into a specific sheet depending on colour
I am looking to have 8 sheets.


Main sheet that has all jobs, these are all currently sorted into the following colours :

Red - live Green - invoiced/complete Blue - quoted Black - enquiry Grey - dead/ lost Purple - work in progress Yellow - Retention
what i would like to do is keep the main sheet and have a sheet for each of the above. when the text becomes red for example i would like it to be transfered to the live sheet and vica versa for the rest via macro.
can anyone help?
Many thanks for you time,