Hi guys! Is there any code that allows me to copy certain cells with a specific color (light grey in my case with 2 as a color index in VBA)? So there are several sheets with the same format and the master sheet with different formats. What I need is to copy certain cells in same column for the entire worksheet inside the workbook with the same background color and paste it on the master sheet. For example, in sheet 1 B6 said Type 1 then B17 type so on, for sheet 2 B6 said Apple1 then B10 Apple2 so on, what I want is to copy the type and the apple to become one straight list, type 1, type 2, apple1, apple2 in the same column but continuously row. Any help would be appreciated, thanks a lot!!
NB: I use Excel 2010 for now
NB: I use Excel 2010 for now