Macro for copying the value of one Cell to another cell(s) in specific time interval

[Swarnendu]

OK, I'll have a look at it

[tirth2212]

I had a look at this earlier; simplified things a bit. I've deleted 9 data connections leaving one live one. Instead of using the built in 1 minute refresh, I've added a 30 second refresh in Module 1 to ensure things are current. The time is added to Row 1 with each update. I've added conditional formatting to highlight changes (for debug) The WB Open has been tweaked to make the starup less confusing. Sheet7 macro has the formula simplified and removes Calculation settings.

Can you Send the excel again? I am having issues running it