VBA Code to Track Changes in Excel Sheet

Corey Laurence 6 Reputation points
2022-03-25T18:36:43.53+00:00

I 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.186959-excel-screenshot.jpg

Developer technologies Visual Basic for Applications
0 comments No comments
{count} vote

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.