tracking

  1. A

    TRACK CHANGES WITH USERNAME & TIME STAMP

    Hi! I have a table that I put into a subform so users can fill out portions of the data. The user will review the work and write in who is responsible, the credit category, cause, and notes. I want to hide the TINITIALS (username) and STAMP (time stamp). I want to use an Event, but I can't...
  2. 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...
  3. L

    Automatic counter based on changes to a cell (inventory usage tracking)

    I am a librarian interested in tracking book checkouts over time. I only need to track how often an item has been used, not when or by whom it was used. My library is too small to justify the purchase of an ILS (circulation software), so I am looking for a simpler solution using what I already...
  4. S

    [VBA] Copy/Paste Values to New Workbook and Separate Tabs

    So I have somewhat of a complex requirement that I need some help with in VBA. I currently have 1 Workbook (Payroll Tracking) which as you can imagine, tracks payroll numbers. Haha. What I would like to have it do, with a command button is to copy/paste (Values) from 1 table to a new workbook...
  5. P

    Summarizing Data from One Worksheet to Another

    Greetings, I know just enough VBA to be dangerous, and what I'm attempting is way over my head. I would be grateful for any assistance. I have a workbook with two sheets named "Tracking" and "Summary". On the Tracking sheet in column A is a number "JobDay" (1 - 5). I want to add the values...
  6. 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...
  7. E

    Tracking

    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?
  8. T

    Pivot with formula for blanks

    I have a sheet, where it points to another sheet. The formula under the heading tracking number is IF(DropIn!G2="","",DropIn!G2). The problem is when I pivot, I am getting a count of all cells where the formula is not just tracking number. I know I can change the pivot each time to remove the...
  9. 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?
  10. B

    Vlookup, concantenate multiple results... Help!

    Good Morning All, Having trouble getting multiple results from a Vlookup. Using Excel 16. Have list with po numbers and they have multiple tracking numbers. Would like to be able to look up po on separate sheet and have all the associated tracking numbers concatenated there... Maybe i should...
  11. K

    Tracking several phase of several manufactured products

    Wise people of the forum... I am in need of a way to do tracking. We manufacturer many different products for many customers. Each product needs to move through several phase of assembly. We would like to move a product through assembly using dates. I have looked at Gnatt chartd but all I can...
  12. P

    Final issue using SUM/SUMPRODUCT

    So, received a bunch of help in my other thread on how to set up some formulas to only look and count certain values that we use for tracking maintenance performed at our Job Sites. The only issues i have left is when tracking 200 and 2000. So, i have the one formula that successfully sees...
  13. A

    Day and Date function

    OK I am trying to build a leave tracking for my organisation. I want the the tracking tab to obtain its information for the month from the leave planning tab. This information is entered as letters. The countifs function gives me an error, the countif means I have to copy and paste this formula...
  14. P

    limiting SUMPRODUCT to a certain value

    So, i have this formula =sumproduct((H2:H500,"Job 1")+(K2:K500,"200")) Problem is sometimes K says 200, others its 200/tire, etc. Is there a simple way that anytime it see "200" that it will count? Basically i have MX events to also track and trying to automate the tracking. I did try "*200*"...
  15. C

    Have excel send an email to Outlook if something is due

    I have a tracking file that remains open at all times. This tracking file has links to other files including status and due dates. I am looking for a tool that would run every morning and check the due date column. If it found todays date in the due date column, it would send an email to...
  16. J

    Leads and Follow-up Tracking Spreadsheet

    Hey Guys, I see this tracking-template is unavailable for download now, wondering if anyone has one similar they use for tracking marketing leads and follow-ups. https://www.youtube.com/watch?v=8Qb9rjl4XmA&t=46s Thanks!
  17. 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...
  18. 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...
  19. 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
  20. 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...

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