VBA Code to Track Changes in Excel Sheet

coreyalaurence39

New member
Joined
Mar 14, 2022
Messages
2
Reaction score
0
Points
0
Excel Version(s)
2019
View attachment EBR - WBR AM Dispatch Log 03.21.22.xlsmI have the attached file and I am looking into creating VBA code that will track changes that are made to the sheet. I would like the changes to be housed in two separate tabs. I would like changes that are made to the cells highlighted in green to show up in the Approval Tracker tab and the cells that are highlighted in yellow to show up in the Change Tracker tab. For the cells highlighted in green all I need is the user name, cell reference, date and time of the change and the data that shows in the cells. For the yellow highlighted portion in the attached file I need the user name, cell reference, the old value, the new value, the old formula, the new formula and the date and time. I am not sure if this is possible. Thank you for any assistance that you can provide for this project.
 
Top