ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Comparing 2 cell updates (https://www.excelbanter.com/excel-worksheet-functions/207368-comparing-2-cell-updates.html)

[email protected]

Comparing 2 cell updates
 
I have a sheet that is pulling in data in real time.
If I have two cells that are updating indepentently, is there any way
to check when each cell was last updated?
Each cell is pulling the same information but from different sources.
If one cell continues to update while the other stops then I know a
source is bad and I want to flag this through the excel sheet.
Hope this makes sense

Thanks,
Karl

Sheeloo[_3_]

Comparing 2 cell updates
 
No unless you all enter the time in another cell while updating.

" wrote:

I have a sheet that is pulling in data in real time.
If I have two cells that are updating indepentently, is there any way
to check when each cell was last updated?
Each cell is pulling the same information but from different sources.
If one cell continues to update while the other stops then I know a
source is bad and I want to flag this through the excel sheet.
Hope this makes sense

Thanks,
Karl



All times are GMT +1. The time now is 04:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com