tracking

  1. T

    Tracking changes

    Hi, I'm trying to track changes from the the sheet "Main" and document/track these changes back in sheet "Tracking". However when I make some changes in sheet main, nothing happens in the sheet tracking. Any idea why? The code I'm using is the following: Dim oldAddress As String Dim...
  2. M

    Macro or formula for tracking raw materials

    Hello, I am not sure if what I want to create is possible but any assistance or guidance in the right direction will be very much appreciated. I am trying to create a spreadsheet that will allow me to track the aluminum and drywall needed in the fabrication of certain frames that we make. The...
  3. B

    tracking in an Excel file

    I know that you can use a tracker in Excel to see who has opened and changed a cell. Is it possible to see tracking information prior to using the tracker to interrogate a file historically, maybe by using another piece of software? I am using Excel 365
  4. M

    Tracking aluminum quantities

    Hello, New to this forum and thanking you in advance for any assistance you can offer. This is what I am attempting to do: Me and my husband recently opened a small shop to fabricate aluminum frames. The orders are starting to come in and I am trying to come up with a system that will allow me...
  5. F

    VBA audit trail - old value not archive

    Hello, im using this code for audit trail, but he is not archive old value. For example when I changed 5 to 10. In log I will have new value only. Could you help me please? Im total newb in VBA. Thank you! Private Sub Worksheet_Change(ByVal Target As Range) Dim Rw As Long Dim strAddress...
  6. dmxcasper2

    Need ideas for history tracking fro specific cells

    Hi all, I need some ideas for tracking the historical changing values. Problem Statement: Column H and I will be revised multiple times throughout daily maintenance of this sheet, however I would like to be able to keep historical snapshots of what the previous information was in these columns...
  7. K

    Need VBA Code for Inventory Sheet

    Hello all. This is my first port here and I am hoping you can help. I am writing an inventory sheet for my company to track some serialized items. In this sheet, I need to include a tracking page for every item sold (easy, I've done that part), as well as a sheet to track voided...
  8. A

    Need template for tracking project tasks

    Help me!!:confused: I have been searching for a template I can use to give me a starting point to create a project tracking document. I need to track several tasks that will have moving dates and be able to have cells change colors for priority, when dates are behind or on target, etc.. I'm...
  9. N

    Making a document tracking / searchable database kind of spreadsheet

    Objective : Need to make a sheets that will serve as a document tracking and a searchable database. Requirement : 1. I need to make a table where I will input data such as tracking number, date, client name, location, status, remarks, and others. It should be able to accommodate continuous...
  10. C

    How to track changes

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

    Vlookup with if function

    Hello, I'd like assistance with figuring out how to determine the name of a carrier based on how the first few characters of a tracking ID begin with. The problem is some characters can instantly identify a carrier by the first character and other can be identified by 2 or 3 characters...
  12. S

    Interacting With API, Send and Receieve

    My company uses a spreadsheet to put all their tracking number on and I'm trying to come up with a solution that will automatically update some tracking info and show it on the worksheet. I found a company online that offers tracking services for multiple couriers and they offer an API...
  13. K

    Highlighting time rows

    Hi! This is my first post on here, I have tried searching for what I need and I can’t find a solution :-( Basically I have a sheet where there is a lot of trips done by vehicles, each trip has to be logged in via a mobile app. On this sheet I need it to highlight the row (red for example)...
  14. O

    VBA Macro for UPS Live Tracking

    Hello, I am new here and quite noob tbh. I would need a VB Macro able to open UPS website for tracking a shipment number from my table ref. and get me a response with the Status appearing in the green field in UPS status. Is someone able to do it?
  15. P

    VBA Macros being deleted when saved

    I'm a real newbie when it comes to VBA and macros so apologies in advance if I'm using the wrong terminology in some of this. I've created a workbook called a Job Sheet Generator. We use this to enter information about a particular job which when we click on a button, saves the workbook as a...
  16. C

    Splitting diffrent hrs for diffrent rates

    Hi all, I have a timesheet which we do our daily hrs tracking. we have diffrent pay rates and there for i want my time tracking to show me diffrent sections this is the formula at the present moment but it calculates all: =SUMIF(TimeLog!$A$20:$A$2146,"=YES",TimeLog!$G$20:$G$2147) i now need...
  17. K

    Macro to generate directory subfolders based on new entries only in tracking sheet

    I'm working on a tracking sheet for a manager that includes automatically-generated file numbers for any new content--so whenever I enter a new line, the number "2018-x" (where "x" is the next number in the series) populates. Because these tracking items will include follow up content, I need to...
  18. gebo84

    Calculate a sum based on a date range

    Hi, I have a spreadsheet that Logs Queries that we receive each day. The queries then have a number assigned to them for how many documents the request is asking for. The date is input into Column B (01-Jan-18 as example) and on the same row in column U there is a number input (3 for example)...
  19. S

    Overtime Tracking

    Can someone help me make a Overtime Tracking Sheet? I would like it to list the Name of the Employee, the Hours they worked that DAY, the current TOTAL hours they have worked for the Month, Quarter and Year, and the Last DATE they worked. I would also like to be able to figure out who hasn't...
  20. P

    Match values in ranges

    Hi All, here is what I want to do, I have Orders numbers from customers in column A and tracking numbers in Column B for example <colgroup><col><col></colgroup><tbody> Order - Number Shipment - Tracking Number 1000-079031-224355 9400111699000770896629 1000-078438-551504...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top