JustTrying9
New Member
- Joined
- Jun 12, 2015
- Messages
- 13
Hi all,
I have a report (.csv) that gets updated once a month. This report tracks client's information such as address, status, etc. as well as a time stamp for when they were last updated.
My goal is for the end user to paste the report in one sheet, have another sheet that looks identical but with any updates highlighted in yellow, and a final sheet that would "track" the updates in a log type of format. It would need to bring in the unique identifier field, old value, new value, and the time stamp for when it was last updated.
I've seen some examples on how to do the first part, but the second part is eluding me. I'm pretty familiar with VBA for access, but still new to Excel.
Any help or ideas would be greatly appreciated.
I have a report (.csv) that gets updated once a month. This report tracks client's information such as address, status, etc. as well as a time stamp for when they were last updated.
My goal is for the end user to paste the report in one sheet, have another sheet that looks identical but with any updates highlighted in yellow, and a final sheet that would "track" the updates in a log type of format. It would need to bring in the unique identifier field, old value, new value, and the time stamp for when it was last updated.
I've seen some examples on how to do the first part, but the second part is eluding me. I'm pretty familiar with VBA for access, but still new to Excel.
Any help or ideas would be greatly appreciated.