Save Workbook When Cells Values are Changed

[DrummerAndy]

I am the lead tester on a project and my team and I use two Excel workbooks to keep track of testing. First, is a testing workbook that each tester uses to organize and track his/her testing on an enhancement. Second is a summary workbook that I use to consolidate all of the testing by the team.

In the testing workbook, Column C tracks the status of each test of an enhancement (i.e. Not Started, In Progress, Completed, Approved, etc.) When a team member saves a workbook, the stats for the enhancement are populated into a database which is then used to populate my summary workbook.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

I would like to have the testing workbook automatically be saved whenever any cell value in Column C is changed so that my summary workbook stats are always current.
<o></o>
Thanks in advance for your help.

 

[Joe4]

Welcome to the Board!

It sounds like a Event Procedure (automated VBA code which is triggered upon some event happening) should do the trick. Simply right click on the sheet tab name, select View Code, and copy and paste this code in the resulting VB Editor window. Note that Macros must be enable for this to work:

Private Sub Worksheet_Change(ByVal Target As Range)
'   Every time an entry in column 3 is manually updated, save the workbook
    If Target.Column = 3 Then ActiveWorkbook.Save
End Sub

For more on Event Procedures, check out this link: http://www.cpearson.com/excel/Events.aspx

 

[DrummerAndy]

Thanks for the help! It works like a charm!