track changes

Hi everyone! first of all thank you all for taking time to help me with my minor problem I am currently intern employee in a big Oil & gas company. They are seeking for a excel document that can track changes when different employee's edits the worksheet. I have already inserted a VBA code...

Hello Everyone, I have a VBA that copies a given sheet from my workbook.xlsm to a new workbook.xlsx and saves it in a shared folder. It works just fine, but I want it to enable track changes on the new workbook.xlsx before closing it. Since I'm not an expert on code, nor whatsoever!, I've just...

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...

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...

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...

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?

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...