Record cell change with time stamp

Migs24

New Member
Joined
May 22, 2021
Messages
1
Office Version
  1. 2013
Platform
  1. Windows
Hi experts. I have a macro when I press, retrieves headcount from an external program by formulas display it on f50 and g50. I want to have vba record any change in values of the range and then pasted on a time table based on 30 minutes period. Eg. 9:01,9:02...9:30 or 10:31..10:32....11:00 (disregard hour, it is per 30 minutes, rinse repeat). If I press the retrieve macro, I need the vba to paste new values to the minute it was run.. ex. If I run retrieve macro by 5:03, the macro will paste the two cell values on the 3rd minute, run again at 5:05, record values in 5th minute. . I have a table 1st to 30th minute on colmun BB1 to BB30 (00:01, 00:02, 00:03). Sorry can't post image file is on office.
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Forum statistics

Threads
1,136,968
Messages
5,678,866
Members
419,787
Latest member
juanam

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