1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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?
  6. 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...
  7. 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?
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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*"...
  13. 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...
  14. 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. Thanks!
  15. 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...
  16. 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...
  17. 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
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...