Thu 4 Jun 2009, 15:52Delegate Jale said...
Jale has attended:
Excel Intermediate course
Protection of worksheets
Is it possible to keep a master copy in my folder of my protected worksheet so that i can see exactly waht new data has been entered and how that has effect the protected worksheet?
Mon 8 Jun 2009, 12:07Trainer Anthony said...
RE: protection of worksheets
Hi Jale, thanks for your query. If I understand correctly, you want to synchronize data between two protected worksheets, including one in your folder. This depends a lot on what the circumstances are, but you could use 3-D links to connect the two spreadsheets together, conditional formatting to visually indicate what cells have changed, or use the import function to bring in worksheet data on a regular basis.
Hope this helps,
Anthony
