record change

  1. E

    Recording cell value (formula) as it changes using VBA

    Good evening, I have two sheets, DataSheet and CalcSheet, in CalcSheet there are 2 cells in table2 (B2, C2, both formula's) whose value's are calculated based off cells in a table1 in DataSheet (where I input and add new data as I go) In CalcSheet, I'm hoping to figure out how to record...
  2. V

    Recording Plugin?

    Hi All, We use an Excel at work that's connected to SQL using 'Data From' function. Are there any plugins out there that can record when a user works on the excel and all the changes they have made? I know Excel had tracking which I used years ago, but it is legacy now and I don't think it can...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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?

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