record change

  1. O

    Excel to record all changes on refresh

    I am NOT the greatest in Excel or VBA. In fact until the last week, I never used VBA, but am learning a lot from Forums and instructional videos. I appreciate everyone of you who participate in these forums and help out those of us who, at times, are utterly and completely lost! I need to...
  2. J

    Using a variable to house a row reference?

    I've been struggling to find and answer to this one and could use some help if it's out there. I have recap sheet with about 50 formula cells, pointing to other sheets, different columns, but all the SAME row. I'm manually updating these 1 by 1 and since the only thing that changes is the...
  3. J

    Record Change in Value from a live feed Cell

    I need VBA cod thatrecords the number of times a cell in a worksheet has a value change. For example if cell J5 contains the live feed, if thatl value is changed to this would be recorded as 1 in the cell using the recording function. If that Cell value is then changed to 11, the cell change...
  4. J

    Record Cell Value Change

    I need a function that records the number of times a cell in a worksheet has a value change. For example if cell J5 has the value 6 entered and that cell value is changed to 15 this would be recorded as 1 in the cell using the function. If that Cell value is then changed to 11, the cell change...
  5. J

    When a field value changes on a record copy record to new table

    I have an asset tracking database to record what asset is assigned to what person. Now I am interested in making a 'real-time' history for each asset. When any field changes on a record the record is copied to a table to inlcude date of record change. Any clue how to do this?

Some videos you may like

This Week's Hot Topics

Top