I hope you can help me with a spreadsheet.
I have a spreadsheet with 3 tabs (AY21-22, AY22-23 and log[hidden]) that I need to track changes on.
I have found
Private Sub workbook_beforesave(ByVal SaveAsUI As Boolean, cancel As Boolean)
Dim wbLog As Worksheet
Dim iLastRow As Integer
So it's not really a question (unless anyone has a suggestion for a better way to go about it) and if this isn't the place to post this sort of thing please let me know, but I've put together a sheet in my budget that tracks the account that my bills are set to auto-pay from and forecasts out...
I have got a macro in an excel file which tracks the username and time of the users opening the file which I definitely need. The problem is that if 1 user opens the file and leaves it open then it doesn't track the name/time of other users who open the file when its in use. Is it...
Alright, so a company that I work with makes racks for a large company to use. They are new and I go in every day and watch the racks when they get placed and make note of the rack number, time in and out, any issues that come from the robot etc.
So we are trying to figure out now, an easy-clean...
I am currently managing a stock tracking file, which is edited manually to a large extent.
Currently, the four significant columns look like this:
Here, column I is the actual quantity in stock. If my code was functioning, which it was as of yesterday (and I have made no...
Good day. I am running Excel 2013 on Windows 10 Home. I have a workbook with several worksheets tracking music. My goal is to take a concert (multiple songs) and track each piece of music. I have columns set up to track the starting time and ending time of a particular song within the entire...
I am currently using the following:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("O:T")) Is Nothing Or Range("W2") = vbNullString Then GoTo Skip
If Range("W2") <= Range("W1") Then
If Not Intersect(Target, Range("A:U")) Is Nothing Then
Is there anyway to make sure that a client cannot see any track changes/previous versions of an excel? I don't think track changes were on when the file was created but we want to make sure the edits/changes cannot be viewed by the client.
Is there any chance to track the changes of a shared workbook in a separate workbook.
Since the workbook needs to be shared with 20 users and adding the code to the same workbook will slow down the file. Since the file consists of 10 excel sheets.
Please help in adding a code to...
i have a "track change" sheet to avoid any anonymous change in my workbook, but i found some error tracking, i hope someone can point me out here with BIG THANKS.
after i loaded all macro in my workbook, my team member will deploy every role to every staffs in their daily duties, what the out...
Hi, Newbie here!
I've built a spreadsheet to track reports that are on track/due or overdue. I've added IF formulas to show the on track/due/overdue items and used conditional formatting to change the cell colour which is working without any problems.
I have chart to show the volume of items...
I am a dispatcher for a delivery company. I need to track 100 employees, 40, vans, what van they are in, if they need help delivering, if they are helping someone else deliver, if they are on their way to deliver and so on. What is the best way to track this info?
I'm building a calendar format spending tracker. I'd like to keep track of daily, weekly and monthly costs; and then also track costs by category (see image below). The tracking by category is what has the SUMIF function not working. I've been trying to select specific cells to look to, but I'm...
I am trying to setup a spreadsheet to track a number of values. I only need to create a running total when the total of 2 columns becomes a positive value and then track it back down to when it moves back to a negative. The data looks like this:
A + B
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...
Please forgive my appalling lack of Excel vocabulary. I'm not even sure what what I'm trying to do is called. :)
I have a spreadsheet to track the time and frequency of occurrences, say phone calls. My data is like:
Weekday Date 9:00 hour 10:00 hour 11:00...
Good day. I'm running Excel 2016 on Windows 10 Pro. I have a workbook hat contains 8 worksheets with 17 Macros. I intend to make this workbook available to other Excel users who wish to track the data that my workbook will track. Each user will have the ability to have tracked items changed...