Good Morning,

I have a large worksheet (50x3400) that some users may need to make changes to. Changes could be in most columns except Column A, RecordNumber. My goal is to create an audit-type worksheet that shows what a user has changed. The user can also delete a whole record or add a new record.

I would like the report worksheet to show something like this:

User (Have function that picks up Excel username)
Date Changed (have function that picks up Excel last date saved)
Record Number (Column A of the row where change occurred)
Column Changed (Text of column header)
Old Value
New Value

If an entire record is added or deleted, the RecordNumber would be filled in and "Record Added" or "Record Deleted" would perhaps appear in the Column Changed field. This seems to me to be a better solution than taking up 50 rows to show how each column changed.

Any suggestions would be most appreciated.

Thanks,
tom