Need help

  • Thread starter Thread starter RoadKing
  • Start date Start date
R

RoadKing

Good afternoon:

Is it possible to enter data on one worksheet and populate another protected
worksheet in succession and remain there after the original data is erased
from the "working worksheet"?

Please keep in mind I am not a programmer. Any help is appreciated.

Thanks in advance
John
 
Roadking,

For it to remain there after the original data is erased then you will need
VBA.

Is it from the same cell in the "working sheet"? Assuming yes then
right-click on the sheet tab and copy and paste this macro into the
Worksheet module:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address() <> "$B$4" Then Exit Sub
' change $B$4 to your own cell
MoveIt = Target.Value

With Sheets("Second Sheet") ' Change to your sheet name
LastRow = .Cells(Rows.Count, 4).End(xlUp).Row + 1
' change the 4 to the Column number that you want
.Cells(LastRow, 4).Value = MoveIt
End With
End Sub



--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top