Sorry, I was unable to figure out a way on how to word my subject but
here's what I'm trying to accomplish...
I have a single worksheet with 4 workbooks inside of it.
They are as follows.
1 MGR Sched
2 Emp Sched
3 MGR Avail.
4 Emp Avail.
What I want to do is add the Managers Availability to workbook 3 and if
there's an "N/A" or some other text/code in the cell on workbook 1 for
the same day or cell then it won't let me enter anything into it. Same
goes for workbook 2 and 4. I just don't want to bounce back and forth
between workbooks. I'm sure there's a way of doing this but I have no
idea what that way would be. :)
Thanks for your help.
Partie™
--
PartieHonteuse
------------------------------------------------------------------------
PartieHonteuse's Profile:
http://www.excelforum.com/member.php...o&userid=31161
View this thread:
http://www.excelforum.com/showthread...hreadid=508224