Auto Paste

  • Thread starter Thread starter umpie
  • Start date Start date
U

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
 
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
 
Back
Top