Copy Value of colored cell into another worksheet using VBA

Copper Contributor

I need to copy the values of highlighted cells (RGD 255,255,0) in worksheet "Rates", into another worksheet "Calculations". I have already highlighted the cells using conditional formatting . These highlighted cells are always found in the same column after each other (example F13,F14,F15 an so on). I need to have these values copied into worksheet "Calculations" starting from cell B2 moving downwards (B2,B3,B4 an so on). Thanks

0 Replies