-
Copy Data from one sheet to another IF cells are specific text colour
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,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules