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?
Bookmarks