MountainParks
New Member
- Joined
- Apr 11, 2018
- Messages
- 1
Hello,
I'm receiving real time power data that is updating every 10 minutes in cells E15,F15. Every time it updates the current values disappear and are replaced with the new values. I would like to record all of the values throughout the day so I can work with the data later. What I would like to happen is every time it updates to put the new value into a separate sheet and insert it into the row below the previous value. Any help would be appreciated as I am new to VBA and have not quite figured out how to do it by searching the site. Thanks,
I'm receiving real time power data that is updating every 10 minutes in cells E15,F15. Every time it updates the current values disappear and are replaced with the new values. I would like to record all of the values throughout the day so I can work with the data later. What I would like to happen is every time it updates to put the new value into a separate sheet and insert it into the row below the previous value. Any help would be appreciated as I am new to VBA and have not quite figured out how to do it by searching the site. Thanks,
