Copy data from one sheet to another if cells are highlighted specific colours

Hi All,

I am looking to copy highlighted cells into a different sheet, either by a formula or marco. The cells are highlighted by conditional formatting.
In the example I've attached I want all red highlighted cells and the name of the person to be added to the 8 Weeks sheet. Same for the orange highlighted cells, I want all of the orange highlighted cells and the name of the person to be added to the 12 Weeks sheet.

A sheet like this will be looked at a few times a month, so would it automatically update the sheets or would there need to be a button say to run a macro to search the sheet?

Thanks

They're on a few ways that you can run automatic code inside of an Excel program. One of them is to write code behind the routine called workbook_open. the other option you have that I know of is to run a task in Windows task Manager or the event manager one of those two that opens the Excel program and targets the file location which would open the exact file and then the code behind the workbook open event I just mentioned would run automatically and at the end of that routine you could issue a closing statement so the workbook essentially closes itself automatically.

To get a handle on the properties you need to know that detect whether cells are shaded in any given color and using the RGB function or strict hexadecimal codes to identify colorations from the color grid, you need to look up the property called interior. That is a property of the range object and of a couple other objects as well. And it has expensable dependency properties of color and a few other things so those are the things that you need to look up for detection and then copy and paste your values from one range to the other from sheet to sheet.

for a universal technique of looking up any code in Excel that you need to read about from microsoft, always Google these words and the results will be given to you in the first five lines of the Google search:

http://Www.Google.Com/search?q=excel....property_name

and of course if you need to look up functions, methods, statements, or objects, then you would leave the property name portion of that web address out and just keep the function name portion and change it appropriately.