I have a workbook on a shared drive and it can only be handled by power users
entering specific data.

This data needs to be reviewed by managers but we would like to have a
mirror copy available for them to view. We have been through passwords on
the original file etc.

We need a dynamic comparison of the orignal and copy and adjustment of the
copy based on the orginal. What is the best business practice or is there
some Excel type software that now exists?