mirror data between cells in different worksheets

Hello dumdum,

Welcome tot he Forum!

Do the cells change because of user input or because of formulas?

Originally Posted by dumdum

When the data in Sheet1 A1:A20 changes it is mirrored in Sheet2 B10:B30
and then when data in Sheet2 B10:B30 is changed it is mirrored in Sheet1 A1:A20

Put this code in Sheet1 Module (Right Mouse Click Sheet1 Tab and select "View Code")

Please Login or Register  to view this content.

Put the same for Sheet2 (obviously changing the appropriate addresses).

see next post

Here's how I would do it to do for the least amount of typing, when I wanted to add to it.
I didn't test this, so back up before using it.
I did put in a debugging test, just change the "If True Then" to "If False Then", when you have debugged it enough.

Put this into Sheet1 & Sheet2 modules.

Please Login or Register  to view this content.

then put the following code into a Standard module
Change the addresses (or add to them as needed) in the section between the '*************

Please Login or Register  to view this content.

Sorry, missed that. I added the sFrom lines just by editing the code in the Forum, so I didn't have the compiler to check and make sure I did this.
Include these 2 lines at the top of "Cells_Mirrored"

Please Login or Register  to view this content.

Foxguy, please post in the default font size. It was set that size so people could conveniently read it.

Thanks.

Hi shg;
I can't see the difference between the default size and size 1. Is my computer different than yours?
I use size 1 because I have trouble reading "Preview Post" without it. Is there some way to change it back to default after I have finished previewing. My editing box doesn't show the [size][/size] tags.

Edited:
Never mind that last line. I changed my editing choices, so now I see the size tags, and I can remove them before submitting.

Originally Posted by dumdum

I have put in the additional lines and the code runs but it does not mirror. Am I doing something wrong. I have followed your instructions. When you say a standard module I have selected insert and then selected Module. Should I be doing something else?

Somehow the macro lost a line. Don't know what happened to it. I lost it somewhere between my VBE and the forum.

Anyway, add this line in the place indicated (hopefully it's in red. My computer doesn't show the colors, so I can't be sure).

Please Login or Register  to view this content.

Forum Rules
Please read and adhere to these simple rules!

#2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

Welcome to the Forum, Avbanovice, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.