Results 1 to 2 of 2

Thread: VBA Code to Track Changes in Excel Sheet

  1. #1
    Neophyte coreyalaurence39's Avatar
    Join Date
    Mar 2022
    Posts
    2
    Articles
    0
    Excel Version
    2019

    VBA Code to Track Changes in Excel Sheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    Neophyte MyForcey's Avatar
    Join Date
    Oct 2021
    Posts
    1
    Articles
    0
    Excel Version
    360
    Quote Originally Posted by coreyalaurence39 View Post
    EBR - WBR AM Dispatch Log 03.21.22.xlsmI have the attached file…
    Your code is locked with a password - Cannot access.
    Last edited by p45cal; 2022-06-23 at 02:22 PM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •