Private sub reference a different sheet

[PingTing]

i have code to set a cells value based on the

Please Login or Register  to view this content.

as follows

Please Login or Register  to view this content.

It works perfectly for staying on the same sheet, but now I want to do something slightly different.

I want the value set to come from the

Please Login or Register  to view this content.

on another sheet. Here's what I have;

Please Login or Register  to view this content.

but this doesn't seem to work. Sheet1 is the sheet where the user will be on whatever active row, and I want the value of I4 on the other sheet to be what the value of G"whateverRow" the user is on on Sheet1. Is this doable?

[JEC.]

The other way around (put this behind the sheet where the activecell is located).

Please Login or Register  to view this content.

[protonLeah]

Sheets("other sheet").Range("I4").Value = cells(Target.Row, "G").Value

[PingTing]

Wonderful. Thank you, JEC.

[JEC.]

You're welcome!