Updating values automatically

pradeep - Aug 19, 2015 at 07:22 AM
I have an issue. I have 2 workbooks. I need to copy data from one work book to other workbook dynamically. That is if a value is changed in workbook1 I needs to be updated in other workbook.