Cells that have been updated

  • Thread starter Thread starter David French
  • Start date Start date
D

David French

In Excel XP, is there a way to tell if or when a cell has been updated?
We have worksheets that are sent out for a Budgeting process to all division
managers.
They input their numbers and then send them back to the controller. The
changes are merged back together to the master workbook.
Certain columns of information are then extracted and exported to our SAP
accounting system. This process may be repeated several times
Each time the worksheet goes out and then back the only items I need to
re-send to SAP are the items that have changed but I have no way of knowing
what lines or cells have been changed.
Is this an inherent function of Merging Worksheets or is there some other
technique that would work better?

Dave French
 
You could colour the changes

Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("A1:H10")) Is Nothing Then
With Target
.Interior.ColorIndex = 35
End With
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top