MrExcel Publishing
Your One Stop for Excel Tips & Solutions

copying contents of most recent cell visited


Posted by declan cullen on February 15, 2002 7:15 AM

How can I show in one cell only the contents of the most recent cell edited in another single sheet?

eg A1 in sheet1 to show the most recent data entry/edit from sheet2


Posted by Tom Urtis on February 15, 2002 8:25 AM

Right click on your Sheet2 sheet tab, left click on View Code, and paste this in:

Private Sub Worksheet_Change(ByVal Target As Range)
Sheet1.[A1] = Target
End Sub

Modify for destination sheet object number.

Tom Urtis

Posted by Declan Cullen on February 18, 2002 8:30 AM

Thanks Tom but this writes the contents of the activecell to sheet1.[A1], not the cell just edited