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?