Copy formatted cells into another sheet

[vicentiu]

Hi guys,

I'm trying to copy cells formatted in specific way into another sheet.
To be more specific, I want to copy cells filled with red color from sheet 1 and 2 into sheet 3.

In Sheet 3, column A is predefined - it contains tables of 6 rows each, separated by 2 blank rows.

In Sheet 1: If in colum B there is any cell filled with red color, then I want to copy the name of the subject into the first table from Sheet 3. After this, if cell B2 is filled with red color, then I want to copy the value from B2 into Sheet 3, cell B2. If B4 is filled with red, then I want to copy value from B4 into Sheet 3, cell B3.


In Sheet 2: If in colum B there is any cell filled with red color, then I want to copy the name of the subject into the second table from Sheet 3. After this, if cell B2 is filled with red color, then I want to copy the value from B2 into Sheet 3, cell B10 (as in example).

Please take a look at the example attached, It might be easier to understant what I want to do. Also, I mention that I will handle about 20 sheets in my daily activity, so, if there is anyone who can help me, please take that in consideration.

Thank you!

[LeoTaxi]

See if this is it

Kind regards
Leo

[vicentiu]

Hi Leo,
It seems to work for the first column (B) but it won't look for any values into the next columns. For example, it should have found the value from sheet 1, cell d2...
Thanks!

[LeoTaxi]

In Sheet 1: If in colum B there is any cell filled with red color, then I want to copy the name of the subject into the first table from Sheet 3. After this, if cell B2 is filled with red color, then I want to copy the value from B2 into Sheet 3, cell B2. If B4 is filled with red, then I want to copy value from B4 into Sheet 3, cell B3.


In Sheet 2: If in colum B there is any cell filled with red color, then I want to copy the name of the subject into the second table from Sheet 3. After this, if cell B2 is filled with red color, then I want to copy the value from B2 into Sheet 3, cell B10 (as in example).

so i dont see in the question the other columns
but i see for it later this day


Kind regards
Leo

[JOHN H. DAVIS]

Why does your sample have Victor 3rd Street on Sheet3? None of those cells are red on Sheet1?

[vicentiu]

My bad...In Sheet 3 should be John 3rd Street.
The ideea is to copy cells filled with red color into last Sheet.
So, the complete explanation is this:


In Sheet 3, column A is predefined - it contains tables of 6 rows each, separated by 2 blank rows.

In Sheet 1: If in colum B there is any cell filled with red color, then I want to copy the name of the subject into the first table from Sheet 3. After this, if cell B2 is filled with red color, then I want to copy the value from B2 into Sheet 3, cell B2. If B4 is filled with red, then I want to copy value from B4 into Sheet 3, cell B3.
The next column that has cells filled with red is D, so copy the name of the subject into the first table from Sheet 3 (column C) and the value from D2 (Sheet 2) into C2 (Sheet 3).

In Sheet 2: If in colum B there is any cell filled with red color, then I want to copy the name of the subject into the second table from Sheet 3. After this, if cell B2 is filled with red color, then I want to copy the value from B2 into Sheet 3, cell B10 (as in example).

Thank you!

[LeoTaxi]

Hello Vicentiu

see if this is any closer to the desired result


Kind regards
Leo

[vicentiu]

Leo, you are nothing but the Best!��
However, when I push the button you've created in sheet 1, it works like a charm, but when I try to run the code from macro list, it will copy only the cells from sheet 2.
Can you give me a hint about what to do in order to be able to run the code correctly from macro list?

Thank you!

[LeoTaxi]

Please Login or Register  to view this content.

think the red change is it


Kind regards
Leo

[vicentiu]

It worked!��
One more thing..
My table from sheet 1 have another line (right behind the names and it is not formatted) that should be copyed in sheet 3 under the line with names. Also, the table from sheet 1 starts with line 11.
Can you copy the code just like you did before?

Thanks!

[vicentiu]

It worked!��
One more thing..
My table from sheet 1 have another line (right behind the names and it is not formatted) that should be copyed in sheet 3 under the line with names. Also, the table from sheet 1 starts with line 11.

Thanks!

[LeoTaxi]

So sheet 1 start at row 11


Kind regards
Leo