Compile Error: Procedure too Large

I'm working in VBA and have a particularly long code that duplicates many times. I know this question has been posted on here before, and my best guess from reading previous threads is that I need to divide my code into several procedures. However, I've tried using several examples and haven't been able to figure it out. Below is just a small section of my code- it runs over 100 rows, so it definitely exceeds the max size. Would anyone have any suggestions as to how I can break this up? Thanks so much.

Please Login or Register  to view this content.

What exactly are you trying to do? It seems like you are trying to change the same cells in a second sheet whenever the cell is chaged in the first sheet. (For example, a change in sheet1 to cell C5 will make sheet2 c5 then same value). Is this correct?

If so, try some variation of the following code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.