Can you do a similar video using Visual Basic to put todays date/time whenever a range of cells is modified, the current date/time can be showed in a cell at the top of the page? I was trying to figure out how to edit the code you used in this example, but cannot figure it out. I dont want the date/time at the end of each individual row, I just want it at the top of the worksheet (we have 1450 items, and simply want to see if ANY changes are made to the worksheet with a quick look to one spot :) Thanks in advance. Love your videos!
@HeyKimmi Thank you for your suggestion. But, you can just modify the range statement as the following one to get that result. Range("H1") = Now() Would love to know if it's worked out for you. Thanks again for reaching out.
@hilix19 I'm struggling to figure out the issue here. So, I just uploaded the file online and put the link in the description. You can download it and investigate the issue yourself. Hope, you'll be able to fix it quickly.
Can you do a similar video using Visual Basic to put todays date/time whenever a range of cells is modified, the current date/time can be showed in a cell at the top of the page? I was trying to figure out how to edit the code you used in this example, but cannot figure it out. I dont want the date/time at the end of each individual row, I just want it at the top of the worksheet (we have 1450 items, and simply want to see if ANY changes are made to the worksheet with a quick look to one spot :) Thanks in advance. Love your videos!
@HeyKimmi Thank you for your suggestion. But, you can just modify the range statement as the following one to get that result.
Range("H1") = Now()
Would love to know if it's worked out for you. Thanks again for reaching out.
why my timestamps always change, everytime i try to fill the other cell, the first cell always change. do you know how to solve it? thanks in advance
@hilix19 I'm struggling to figure out the issue here. So, I just uploaded the file online and put the link in the description. You can download it and investigate the issue yourself. Hope, you'll be able to fix it quickly.
@@xlpedia thank you so much for your help 😄