I need to copy the entire contents of one workbook to another workbook
automatically. i.e. a duplicate of my original workbook, when i make changes
in my original workbook, it should automatically update my duplicate workbook
as well. Is this possible?

hi,

That's a backup, why don't you just save it twice under different names.

Mike

"jamal" wrote:

> I need to copy the entire contents of one workbook to another workbook
> automatically. i.e. a duplicate of my original workbook, when i make changes
> in my original workbook, it should automatically update my duplicate workbook
> as well. Is this possible?