Hi
I'm sure this is relatively easy - I am just trying to create a VBA macro that anytime a cell's *value* changes (from an external data source) it will insert a new row and copy down the data
For example here is some data I have in a sheet where cells
B6 = Current Timestamp
C6 = Current Data
Whenever there is a change to Cell C6 (ie the data changes) ->> it should insert a new row and paste in the data so it would look like the example below
<colgroup><col><col></colgroup><tbody>
</tbody>
I'm sure this is relatively easy - I am just trying to create a VBA macro that anytime a cell's *value* changes (from an external data source) it will insert a new row and copy down the data
For example here is some data I have in a sheet where cells
B6 = Current Timestamp
C6 = Current Data
Whenever there is a change to Cell C6 (ie the data changes) ->> it should insert a new row and paste in the data so it would look like the example below
Current | |
08:35 | 73 |
Previous | |
08:34 | 70 |
08:33 | 67 |
08:30 | 66 |
08:29 | 65 |
08:20 | 62 |
08:19 | 59 |
08:02 | 58 |
07:45 | 54 |
<colgroup><col><col></colgroup><tbody>
</tbody>