Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 3rd 06, 06:55 PM posted to microsoft.public.excel.newusers
PartieHonteuse
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:03 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017