Auto Paste

[umpie]

Please Help

I need to find a way to have whatever data I imput on one page in a
certin cell to appear on another page (within the same file) in a
certin cell. PLease Help

 

[Don Guillett]

Right click on the sheet tab>view code>insert this>save workbook
Change to suit your needs.Works from cell a1 to copy to sheet3 cell d5

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$A$1" Then Exit Sub
[sheet3!d5] = Target
End Sub