1. J

    Macro to keep track of username and time for users who opens an excel file

    Dear Team, 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...
  2. L

    Help figuring out how to do this.

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

    VBA code not working anymore?

    Hello everybody, 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...
  4. Dan Wilson

    Working with minutes and seconds

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

    Track changes on a Worksheet in Excel with VBA

    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 Call...
  6. J

    Excel removing any edit history/track changes

    All, 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. Thanks, J
  7. F

    How to track changes of a shared workbook in a separate workbook

    Hi All, 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...
  8. K

    track change in my workbook

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

    Formula Assistance

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

    Home Service

    Hello, Does anyone know of a good way to keep track of a Home Services business? Thanks
  11. E


    Will Excel keep track of invoices? Example; I generate and invoice and the next day i generate another, will excel store the info and add them up to track income?
  12. H

    What kind of form do I need?

    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?
  13. L

    SUMIF in Calendar Format (Too Many Arguments)

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

    Running Total reset by negative value

    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: <tbody> Value A Value B A + B Required Result...
  15. Z

    Tracking driver limites

    Our truck drivers are not allowed to work more than eight 12-hour days during a 30 day period, is there a way to track this?
  16. 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...
  17. G

    counting trends over time - by hour, and by day

    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...
  18. Dan Wilson

    Macro editing

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

    "Co-authoring doesn't provide track changes" - what to do?

    Hi, 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...
  20. J

    Using data fields for 2 purposes

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

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