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...
I am currently working on a template to be shared among several people within the organization. It is suppose to be stored in a sharepoint using the web. The idea was to generate a backlog where you could see all changes that people have been doing. The purpose for tracking the changes is...
I have a large spreadsheet to track golf statistics by player, by day, participating by month. Each day a player participates they get a $0 or a positive dollar amount depending on their results for the day. Currently I have a =COUNT formula to track the number of days each participates and it...
I'm creating a tracking document for the real estate team I work with. I'm in way over my head in excel skills (this is news to no one on the team, we just realized it's cheaper for me to spend the hours to make this document and have it as our own rather than pay for the one we've been using...
I wish to catalogue my albums but when they are in excel they are shown by the track number first
06 Killer Queen
02 Spirit in the sky
96 life on mars
Some are even shown as
1-01 sweet Love
2-02 Strut your funky stuff
I wish to remove the fist word in the string and report just the song title...
I have a text string in excel that is a series of notes delimited by <> following each note
So an example would be:
It is going well - I hope; we'll know more next week<>Project is slipping - more to some<>Project is on track as of 7/7/18<>Well, it's back off track as of 7/15<>