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 Im trying to do: =if(c11=€�x€�,go to d11)

Thanks in advance!!!!

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


"Copper6203" wrote in message
...
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!!!!

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,"")

"Copper6203" wrote:

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 Im trying to do: =if(c11=€�x€�,go to d11)

Thanks in advance!!!!

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

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!!

"QC Coug" wrote:

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,"")

"Copper6203" wrote:

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 Im trying to do: =if(c11=€�x€�,go to d11)

Thanks in advance!!!!