how do i Double click a cell with a variance and it take me to another worksheet

[KassieS]

I have a large spreadsheet with number variances to budget. I want to be able to click on a large variance and it take me to a different worksheet and enter a specific value into a specific cell. Is there a way to do this?

Example if I double click on cell A4 in sheet1 I want it to take me to sheet 2 and enter the value of cell A1 from sheet1

Anyone have any suggestions? Thanks in advance

 

[alansidman]

Look here and see if one of these solutions will work for you. You will have to build links for this occur.

 

[KassieS]

Look here and see if one of these solutions will work for you. You will have to build links for this occur.

This link does not work...thanks for the reply tho

 

[My Aswer Is This]

Try this:
Put this script in Sheet(1)

If you double click on sheet(1).Range("A4") the value in A4 will be entered in sheet(2) Range("A1")

If this is not what you want modify the script or clear me up on what you want.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Intersect(Target, Range("A4")) Is Nothing Then
Cancel = True
Sheets(2).Range("A1").Value = Target.Value
Application.Goto Sheets(2).Range("A1")
End If
End Sub