tracking changes

Is there any way to highlight a cell that has been edited recently? (e.g. within the last 14 days) I am working with a report that potentially changes on a weekly basis which is shared on teams with some colleagues. A lot of the time there may be minimal changes, but there is a lot of data so it...

HI, so my issue is as follows. I have a master workbook in which I would like to track changes that were implemented in other workbooks in dofferent locations. The workbooks are all including the master saved in different locations on sharepoint. Now what I would like to track are changes in...

Hi there, My coworker and I are in need of either a code or a macro to help us out. Our staff track their work on an excel sheet currently with various tabs and functions. They turn the documents in weekly, and we are trying to see if there is a way that we can see when changes were made to...

Hello, I'm wanting to create an indicator that shows me when a project has overspent for multiple months or under spent by multiple months. I want to do this for over 50 projects. I have monthly spending by project. I'm considering using outlier formulas to show me when spending is abnormal...

I have a piece of code (Which I got from this site) that tracks changes to cells within the worksheet. It works great except I'd like it to look a changes just within one column only, not the whole sheet. Anyone know of a way? Option Explicit Const intUsernameColumn = 1 Const intCellRefColumn...

I have been trying to set one of my company's excel documents to be tracked. I have found it, I have set it up and it works really well. Only issue is, it makes the document [Shared]. The issue with this, is that the document is on a shared drive, we have tried to have it shared before but it...

Hello Again, I have a code running (code below) that is copying data from one master sheet, to one of 2 other sheets based on criteria. What I need to do now, is add a code to this (for the whole workbook) that will track changes made. So if by example, John opens the book, and enters a new...

Hello, I have one cell call "Above" and the other one call "Below". Sometimes, "Above" will change to "Below" and vice versa. I want to be able to tell how many days since the cell changed from "Above" to "Below" For example: Cell A1 change from "Above" to "Below" on day 1------> Cell B1 = 1...

I have a database where the status of a part can change from being in, out, lost, etc. I would like to track when the part goes Lost. I created another field to do this with but when the status changes, the field I create changes. I would like for it to remain as it is no matter what the status...

This post is really to ask for a good suggestion on how to accomplish this task. I have made a Template in excel that calculates sales opportunities. The first few columns data is directly imported from the amount of new business sales. The last few columns is where the formulas are stored...

I am trying to setup a worksheet to file save as G5, J4 & J5, have that working except would like to remove the path. I want to the file save as box to show up to designate where to save the file as of right now it is saving automatically (and everyone sets up their computers differently...lol)...

Good morning, I have two excel workbooks formatted exactly the same. Is there a way that I can compare the two documents and highlight the cells with changes throughout the entire workbook?

Hey guys, this is my first time posting on the forum but I have always gotten a lot of help from reading other posts. Here is my question: I have a workbook in which I have created a tracking program with a user interface, the information posted to the interface gets stored into hidden...

I want to be able to measure the progression of a cell that is in a dropdown in Excel. Once the cell "closes" it is important but it is more important to see what the cell was before it was coded as closed. Is there a way to see what the last item in that cell was? maybe put it in another cell?

I am working in Excel 2007 Compatibility mode. I am needing to find out how to track changes within a shared workbook (on a server) that identifies who made the changes, and I need to be the only one who gets this info. Not the others using the workbook. Is there a way that whenever ONLY I...