"go to" Macro help please..

[rudgeworks]

I need to take the data from formula (a numeric value) and use this to automaticly move the cursor to a specific cell which is based on this result. IE in simple terms Formula (2*300) gives a result of 600, I need to then move to cell A600, if result is 150 then I need to move to cell A150.
Sounds so simple, but I have spent ages trying to do this... can anyone help?
(Excel 2007 if it makes a difference)

 

[VoG]

This certainly seems possible. Which cell contains the formula and what is the formula?

 

[rudgeworks]

The formula is =F22*100 and the result is shown in F23.

I tried recording a macro pasting the result (in F23) into the dialog in the "go to " tool, but that does not work, as the macro sets the result in stone and always gos to the same cell.

 

[VoG]

Assuming that you are entering the value in F22 (i.e. F22 does not contain a formula) then try this. Right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "F22" Then
    Application.Goto reference:=Range("A" & Range("F23").Value), scroll:=True
End If
End Sub

then close the code window using the X.

 

[rudgeworks]

Many thanks ill give that a go............

Much appreciated...