Event change copy paste

I have two worksheets, and when the value in one changes I'd like the value in the other to change as well. Pasting a link doesn't work, because on the "Paste to" sheet I've applied conditional formatting, and it doesn't register a change event when it's a pasted link. I tried running a macro to copy the whole column and paste it on a change event, but that didn't alert the conditional formatting to kick in.

The "Paste From" sheet has dropdowns in column C. The "Paste to" sheet has corresponding dropdowns in column F. So, if someone changes the selection in C3 on "Paste From", I'd like F3 on "Paste to" to change. Is there a way?

Originally Posted by jomili

... and it doesn't register a change event when it's a pasted link.

What does this mean? Does Conditional Formatting work on an event? I set up two workbooks with a link and conditional formatting that said if cell > 10, background color = red. When I changed the value in the book to 11, the linked cell turned red.

I see, so the real issue here is that you have a macro to change the strikethrough on your font, but it only runs on a worksheet change event. If the change isn't made to that worksheet, i.e. to the linked worksheet instead, the strikethrough doesn't change.

Can you switch the code on the "Paste From" sheet to something like this?:

Please Login or Register  to view this content.

It is more efficient than copying and pasteing, and will trigger the event on the "Paste to" sheet.

You're most welcome, glad I could help.

Please Login or Register  to view this content.

Takes the Target, which is the cell clicked, and makes the variable i = the row.

Please Login or Register  to view this content.

You're right on for this one.

Please Login or Register  to view this content.

To make this two lines lower, add two to the row like so:

Please Login or Register  to view this content.

By the way, I'm far from a master. But most of what I know I learned at this forum. Thus, I pass on your praise to all here.