Is there a go to function in excell

[Guest]

Is there a "go to" function in Excel? What I want to do is have a conditional
if statement where if data in the previous cell equals a given variable, then
you would be automatically redirected to another cell.

This is what I’m trying to do: =if(c11=â€xâ€,go to d11)

Thanks in advance!!!!

 

[Peo Sjoblom]

You can only do this by using an event macro which of course can be turned
off when the user opens the workbook

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Guest]

The following formula will look at c11 and if it is x it will pull the value
for d11. If it isn't X then it will be blank ("").

=if(c11=â€xâ€,d11,"")

 

[Carim]

Hi,

Only with an event macro stored in the worksheet module ...
Private Sub Worksheet_Change(ByVal Target As Range)
Set Target = Range("C11")
If Target.Value = "x" Then '<<<< change cell
Application.Goto Range("D11")
End Sub

HTH
Cheers
Carim

 

[Guest]

WHat I'm trying to do is actually move the pointer from the "c11" cell to the
cell "d11" cell. I have been able to figure out move the data from one cell
to another. What I have set up and am trying to do, is a form in excell where
I have yes, no, and don't know data cells. If a student puts a "x" in the yes
cell, I want to then have the pointer move to the next "yes" cell in the next
row down.

Thanks!!