Hi all! I was wondering if someone can help me out with this problem:

I have a worksheet in Excel onto which I export Claims information for
our company. There are 10 columns (fields) on this sheet, with the
last column labeled as "Latest?" - the way things work, a person
updates a Claims transaction and exports it to this sheet. We use this
sheet to see any or all updates made to our Claims transactions,
however, we need to see which one is the latest. So, let's say Claim
transaction ARGENT-Claim07 gets updated (one or two fields are
changed); the user makes the changes on another sheet, presses a
Export macro button, and everything gets copied over to this sheet.
What I also need done is to have the "Latest?" column say "Yes" to
this updated transaction and change the "Yes" to a "No" for the
previous ARGENT-Claim07 transaction. Can someone help please?

Sorry if this was confusing - please let me know if you have any
questions and I'll do my best to answer. Thanks in advance!