NoviceJESS...
Hi Kevin - thanks so MUCH for attempting to answer my question (I've tried
everyone at work and we're all stumped). Here's more detail. In one folder
called "2005" - I have 6 workbooks. 5 of the workbooks belong to different
departments in the company. The 6th one is a rollup of all those numbers -
MTD and annualized, so the need for sensitivity is gone. Each fitness club
has a "2005" folder and we have 40 clubs. The Five documents have common
nomenclature across all clubs.
I'll pick one club to use as the example - Gilbert, AZ and their "2005"
folder contains the following:
First - the 5 source workbooks have 16 worksheets each. All worksheets are
password protected individually. The 5 workbooks also are "file
protected" -
for open and write access.
The names a
1. "2005 Matrix GIL Aqua" (for Aquatics, password is ant)
2. "2005 Matrix GIL CC" (for Child Care, password is cow)
3. "2005 Matrix GIL Day Ops" (for Day operations, password is duck)
4. "2005 Matrix GIL Night Ops" (for Night Ops, password is nag)
5. "2005 Matrix GIL FD" (for Front Desk, password is frog)
The 6th doc is a rollup doc and has four worksheets - all worksheets are
protected individually (mainly for formulas and editing). The 6th doc for
Gilbert is called "GIL"
"GIL" does not need to be "file protected" - meaning - anyone can open,
view
and enter in information. The worksheets in "GIL" are protected so that
people with little Excel skills don't try to add or remove rows or columns
(I
hate that!).
Hope that helps - really really appreciate you taking the time to look
into
this!
My email at work if it's easier is:
have a good one Kevin!
Jess
Hi Jess,
This on the surface doesn't look too difficult (famous last words).
I will send you an e-mail and we can go from there.
Regards,
Kevin