track changes

  1. V

    Recording Plugin?

    Hi All, We use an Excel at work that's connected to SQL using 'Data From' function. Are there any plugins out there that can record when a user works on the excel and all the changes they have made? I know Excel had tracking which I used years ago, but it is legacy now and I don't think it can...
  2. D

    Record data based on a time stamp

    Hi All, I control a monthly sales forecast - sales people enter their forecast for the month but then can amend this at 2 dates in the month (approx 10th and the 20th), it is then fixed. I need to track the changes they make; example. Cell B1 they enter £100,000 for June On the 10th they may...
  3. A

    Issues with Tracking Changes in MS Excel

    Hi all, Recently I have been toggling withthe Track Changes in MS Excel and realized that it can only track editedchanges such as words/numbers etc but it is unable to track whether a cell is highlightedor not in the History tab? So for example, if I’ve simply changed a cell fill fromblue to...
  4. R

    Show changes (Track Changes or similar) in a new cell

    A1 - original sentence B1 - edited sentence C1 - is there a way to show what has changed similar to track changes in this cell? A1 - My name is Chris B1 - My name is Dave C1 - My name is ChrisDave The word Chris would have a strike throguh it?
  5. Y

    Log Changes with VBA

    Hello, I am trying to find a way how I can log all changes made to the workbook. I have found a perfect piece of code on a forum thread here. I will link the code: Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Dim LR As Long, X As Variant If Sh.Name = "Log" Then...
  6. D

    Filtering to show changed cells - is it possible without resorting to macros

    We have a reporting spreadsheet, used by our PMs, with a text input cell for the PM to provide a brief update on the week's activities. I know I can Track Changes, which will put a small flag on a changed cell, but is there a way that can feed into another column/cell to show that the status...
  7. L

    Auto Update Time Stamp?

    Hello, I am trying to have a cell (or cells) that log when the last change was made to a shared workbook. I have tried a few options through VBA that I found through searching:Public Function ModDate() ModDate = Format(FileDateTime(ActiveWorkbook.FullName), "m/d/yy hh:nn ampm") End Function...
  8. B

    Issue related to VBA Track Changes Control

    Dear all, I am trying to use th VBA to control the function of Track Changes and i would like to know about the code.Please share to me. First of all, i would like to use VBA to : 1.trigger the Track Changes function 2.tick the box of Track changes while editing.This also shares your...
  9. W

    Message in a bottle_WORD2010 VBA_Combination of track changes reviews into one document

    Dear all, That might be more a message in a bottle because WORD VBA is not the most looked for but I take my chance on this active forum. What I would like to do: I sent a WORD2010 document into review and I collect the reviews from my colleagues as track changes. I would like to combine all...
  10. J

    Table showing a cells previous values using vba

    Apologies in advance as I think there are some threads covering similar topics, but I have been unable to get the vba in them to work as needed, as I'm pretty new to it. I am creating a risk register table (in a worksheet called Risk Register) with values added and updated from an input macro...
  11. D

    Tracking data changes with Power Query

    I am using Microsoft Excel 2010; 32 bit I have a workbook query set up through Power Query that returns a table (24 columns, 12,000+ rows). It is a web connection to a DB2 (authentication required). I have it set up so that the first column is the modified date (date and time stamp). The table...
  12. R

    Audit Trail - VBA - Tracking related cells

    Hi MrExcel Community, It's my first post here - so "Hello" :-) Currently I'm using this Audit Trail Macro to track cell changes in multiple sheets: Option Explicit Dim sOldAddress As String Dim vOldValue As Variant Dim sOldFormula As String Private Sub Workbook_TrackChange(Cancel As...
  13. D

    VBA to track History changes from a worksheet to a new worksheet

    Hello I need help and not able to find my solution. I have in a sheet called TOC on cell J33, which updates every 2 minutes based on a = function to another sheet that uses a api query. My goal is to track last value (history) before it updates, and have the data output on another sheet...
  14. V

    VBA code to Track changes in a workbook

    Hi, I am working on a shared file which is being updated by multiple users. I am not able to track who changes what. Can we have a "Update Log" sheet which captures the following details - 1. Date & Time 2. Modified by which User 3. Sheet Name that was updated 4. Cell Reference 4. Old value 5...
  15. H

    Dupliate with value changes

    Hey Guys, This one has been allusive I am hoping one of the geniuses here can help. I have an order calculator I developed for my business, I place all my orders Monday for the week, I am having an issue where if I should change my forecasted ales during the week the value of the amount...
  16. M

    Tracking changes to a column and preserving Undo

    Hi I know the Undo stack is cleared when running a macro. I'm trying to maintain in one column the current date of when a cell in another column is changed. The code in the specific Sheet is: Private Sub Worksheet_Change(ByVal Target As Range) If Not (Intersect(Target...
  17. T

    VBA Code to Track Changes in Excel

    Hi Again, I have a code (copied below) that copies data from a master sheet, to one of two other sheets within the same workbook. This is running in a 2016 Excel workbook that will have multiple people from multiple departments working on it, logging in via an intranet. What I need now, is a...
  18. R

    VBA Code to Track Changes in Worksheet

    Hello Everyone, I'm trying to incorporate a code that will track all changes made to a worksheet. The code below works great, however, I can't get Target.Address to update when I insert a row. For example, say if I put "test" in A4, and I insert a row, and "test" is now in A5...I can't get the...
  19. B

    Reference Cell in Track Changes VBA

    I am using the below code to track changes in the "V&O Register" tab of a workbook I'm using. I would like the 8th value that it spits out (highlighted in red below) to be the value in column B of the same row that the initial change is being made in. The changes are being tracked in a separate...
  20. D

    How to track form control changes

    Hello VB experts I could really use some help on recording changes to a a form control such as a check box. I have the check boxes associated to cell ( one for each control different control) I have this code to record changes to a "log" sheet. It is working fine but when I check a check box or...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top