saving changes
 

Hello Group,

new to Excel programming but I do have VB background.

I have been given a spreadsheet that the users seem to have a problem with
keep straight who changed what. What the are proposing is to have asecond
Worksheet to record all changes. The changes would appear on the second
worksheet in columns something like this:

Row Field Before After
Date
Number Name Update Update

1 Address 123 Elm 7890 Main Street 1/1/2006
7 Amount $1.00 $2.00
2/2/2006
8 Address 444 Main Str 123 Elm
2/2/2006

Does any one have any suggestions? I saw a little chunck of code that I can
use a as a trigger if anything changes - that was good but I now need to
figure out how to place the before and after contents of the cell into the
second worksheet.

Rich