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?