"go to" Macro help please..

rudgeworks

New Member
Joined
Aug 22, 2008
Messages
3
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)
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

VoG

Legend
Joined
Jun 19, 2002
Messages
63,651
This certainly seems possible. Which cell contains the formula and what is the formula?
 

rudgeworks

New Member
Joined
Aug 22, 2008
Messages
3
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

Legend
Joined
Jun 19, 2002
Messages
63,651
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

Code:
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,699
Messages
5,470,261
Members
406,686
Latest member
BNR_ 1980

This Week's Hot Topics

Top