Copy colored cell automatically into other cell

Dear forum users,

I want to create an excel sheet containing the pagination of a newspaper. This newspaper consists of multiple (8) editions that get change pages on the previous printed edition.
The printing order is as in the attached example.

HAA is printed first and then there are a number of change pages in IJC. These are given a color and those cells should be automatically colored in the second schedule.

I was able to make this with vba but should be able to do much simpler in my opinion.
This vba is not complete, I only made the HAA.

Grtz,
FvdF

Hi,

like this, see attachment.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hello cysu11,

Your code seems to work well, super thanks for this.

Do have another question though, can the change pages that are next to each other also be automatically summed in the cell at the bottom of the column (see image).



Grtz,
FvdF

Here my latest file.

With Regards,
FvdF

Hi,

like this, see attachment. I see your default color is blue?

Please Login or Register  to view this content.

BR, Alexandra

Best,

I am in the process of entering this sheet and so far it conforms to what I requested.

Therefore, super thanks for this code and modifications.

With Regards,
Frans.

Hi,

you´re welcome, i´m glad that i could help you!

BR, Alexandra

If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved"

Hi,

Something went wrong when counting the change plates. I think it has to do with the color, which has changed again.

Is it possible to count without taking color into consideration?

Second, constantly refreshing this sheet is quite irritating. Is it possible to do this without refreshing the sheet?

With Regards

Hi,

1. how should be possible to count without taking color into consideration, even when this is the only thing you change? So please let me know, what is you default color, let me know one cell which have the default color?
2. Would you prefer a button to start the code, when you are finish with you color change in the left table? Now the code start at every selection.change in left table...

BR, Alexandra

Okay I understand that now.

Surely I can adjust this color myself just can't figure out (yet) where this number comes from?
Interior.Color = 16750950

The default color then becomes no color, or is this also difficult? Then light yellow please (RGB 255/255/200)

Hi,

Interior.Color = 16750950, it means the numeric layout/display for RGB(102, 153, 255) it means blue, this color you haved in the last uplaoded file in post #5.

Now you want the default color becomes no color, the numeric layout for this is 16777215.

So the code will count now all the other colors <> 16777215. Also the refresh is now not more visible, but now you will see only the affected cells changing.

Please Login or Register  to view this content.

BR, Alexandra