tracking

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

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

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

I've been tasked with a project that requires something more robust and secure than Excel macros. In the distant past, I wrote projects like this using Visual Basic. Since Visual Basic has gone the way of the Pony Express, it's not an option. I was thinking about using Visual Studio, but...