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

[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

 

[J Sedoff]

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