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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Forum statistics

Threads
1,136,862
Messages
5,678,197
Members
419,750
Latest member
crp

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