VB codes
 

How do you update/append/delete records in various files automatically based
on the entry into the Summary file.

VB codes
 

Your question is rather vague, but the core of the answer is to use
the Change event to execute the appropriate code when a value on the
Summary sheet is changed. Right-click on the sheet tab of your Summary
sheet and choose View Code. In the code module that opens up, enter

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Cells.Count 1 Then
Exit Sub
End If
If Not Application.Intersect(Range("A1:A10"), Target) Is Nothing Then
' your code here
End If

End Sub

This code will be automatically exectued when a value on the worksheet
is changed. The code test whether the cell that was changed (Target)
is within the range A1:A10 and if so then executes whatever you put in
the line ' your code here.

The Change event is triggered when a cell's value changes as the
result of the user typing in a cell or as the result of other VBA code
modifying the value, but not if the change is simply the result of a
calculation.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com





On Tue, 18 May 2010 09:36:14 -0700, Val
wrote:

How do you update/append/delete records in various files automatically based
on the entry into the Summary file.

VB codes
 

See if Ron's page helps:

http://www.rondebruin.nl/summary2.htm


"Val" wrote in message
...
How do you update/append/delete records in various files automatically
based
on the entry into the Summary file.