If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Compare 2 workbook(s) data and then go from there..
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 |
Thread Tools | |
Display Modes | |
|
|