Dear Team,
i am new in VBA using macro by record macro only. Kindly help to correct the below mention VBA code. I want to select a cell in sheet1 based on the cell value in sheet2(cell E3). E3 contain the Cell address of required cell selection. like in below macro address is "A10". but it should be dyanamic. if E3 values changes to A15 or A11 it should select A15 or A11 cell of Sheet 1.
Kindly help.
Sub Macro2()
'
' Macro2 Macro
'
'
Range("E3").Select
Selection.Copy
Sheets("Sheet1").Select
Application.Goto Reference:="R10C1"
Sheets("Sheet2").Select
Range("E4:G4").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Sheet1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Sheet2").Select
Range("E2").Select
Application.CutCopyMode = False
ActiveWorkbook.Save
End Sub
Kindly help
i am new in VBA using macro by record macro only. Kindly help to correct the below mention VBA code. I want to select a cell in sheet1 based on the cell value in sheet2(cell E3). E3 contain the Cell address of required cell selection. like in below macro address is "A10". but it should be dyanamic. if E3 values changes to A15 or A11 it should select A15 or A11 cell of Sheet 1.
Kindly help.
Sub Macro2()
'
' Macro2 Macro
'
'
Range("E3").Select
Selection.Copy
Sheets("Sheet1").Select
Application.Goto Reference:="R10C1"
Sheets("Sheet2").Select
Range("E4:G4").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Sheet1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Sheet2").Select
Range("E2").Select
Application.CutCopyMode = False
ActiveWorkbook.Save
End Sub
Kindly help