retrieving last date values were changed

I

Ify

Hi,

Thank you for your help .


I need to be able to find out the date when a value on a linked shee
in another workbook was last altered.

Example:

Workbook1/sheet1

amount
1000
2000
2000
1000
_____
£5000


workbook2/sheet2
amount date altered(if different from workbook1/sheet1)
_______
£5000


if the amount on workbook1/sheet1 changes(£5000), what date was th
change made.

Thank you
 
Top