I did that and it works but only in J7. I went to the code and tried taking
out the $ but that doesn't work (a total stab in the dark on my part). Any
suggestions?
"Mike H" wrote:
Karen.
Right click the sheet1 sheet tab and view code. paste the code below in on
the right hand side. Close VB editor and you should be OK.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$J$7" Then Exit Sub
If ucase(Target.Value) = "YES" Then
Application.Goto Sheets("Sheet3").Range("C2")
End If
End Sub
Mike
"Karen D" wrote:
No, not ready for VB (as much as I would like to be). What I am trying to
do: A person selects "Yes" or "No" in cell J7 on sheet1. If "yes" is
selected, I would like cursor to jump to sheet3 C2. Somehow if I could tell
it "IF J7=YES, GOTO Sheet3!C2" - am I making sense?
"Mike H" wrote:
Hi,
You can't do that with a formula, you need VB. Are you ready for that? If
you are then post back and we'll show you how but will need a bit of an
explanation of what your trying to do.
Mike
"Karen D" wrote:
I thought that might work but it doesn't bring the curose to that cell in
Sheet2, it pulls whatever value is in that cell...there used to be a "goto"
function I thought...?
"Mike H" wrote:
Hi,
Maybe this
=IF(A7="Yes",Sheet2!A1,Sheet3!A1)
Mike
"Karen D" wrote:
If a condition is met in a cell (A7='Yes'), I want it to go to another sheet
in the sameworksheet. Does anyone have any suggestions on how to do this?