i have code to set a cells value based on theas followsPlease 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.Please Login or Register to view this content.
I want the value set to come from theon 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?Please Login or Register to view this content.
Bookmarks