if any cell value changes, then display in some other area that va

  • Thread starter Thread starter Deepti
  • Start date Start date
D

Deepti

Hi,

I have one sheet in which i have linkage of many sheets, everymorning i need
to take print of that, but most of the time, some information will not
updated. how i can know that all information is updated.


Thanks
 
If you know where the files are (the ones that are linked), check to make
sure that they have been updated that morning (in the Explorer Window, View
--> Details, look at "Date Modified" column).

There is a more complicated way (create macros that copy data to a new sheet
and check it against the supposedly "updated" data), but this would probably
work for you.

Hope this helps, Jim
 
Back
Top