"or is there some Excel type software that now exists?"

Though it is not completely clear to me what you are trying to achieve,
possibly the commercial add-in "XL Companion", from yours truly,
will do what you want... http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA
(Excel Add-ins / Excel Programming)


"karenp"
wrote in message
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?