display info

[red95]

i have main sheet h27 is =input!C27
input sheet c27 is =Sheet1!A27
sheet1 sheet a27 is 2271
i want to incert a row in front of a27 and have the data be 9999 and the data on main sheet c27 change to that 9999
any help

thanks red95

 

[venkat1926]

the full logic is not clear

try this macro

Sub test()
Dim r As Range
With Worksheets("sheet1")
Set r = .Range("a27")
r.Offset(-1, 0).EntireRow.Insert
r.Offset(-1, 0) = 9999
End With
With Worksheets("main")
.Range("C27") = 9999
End With
End Sub