VBA Code To Mirror Cells from one Worksheet to another

**Daniel1234** · 03-04-2010, 12:20 PM

I am quite new to this forum so I apologise if I do something incorrectly.

I need to mirror individual cells from one worksheet to a multiple of other worksheets within the same work book. I was wondering if anyone had written a code that could do this that I could copy and paste in and edit to fit this document.

I have had a reasonable look through the forum for this answer but cant seem to find one that fits.

Thank-you,

Daniel1234

**6StringJazzer** · 03-04-2010, 03:37 PM

This is a fairly simple-minded version but works:

Please Login or Register  to view this content.

This code must go in the code for the worksheet that is the source of the data. I took you literally when you said "mirror"--this puts values in the same cell in the destination that is used in the source.

Further, this code will copy all of the values of interest every time there is any change anywhere on the source sheet, even if the change is not one of the values to be copied. It is not difficult to make that more efficient but I didn't want to write a lot more code without knowing the specifics of your situation.

(Also, note that you posted to the Excel General forum, but are asking about VBA code. There is a forum specifically for that called Excel Programming.)

**Daniel1234** · 03-05-2010, 05:44 AM

When i pop it into the view code section i get this error

Run Time error '9'
Subscript out of Range

if i click on debug this line is highlighted in yellow

Worksheets(wsName).Range("A1") = Range("A1")

(Sorry for posting in the wrong section will make sure it doesnt happen again)

Thanks,

Daniel1234