Compare 2 workbook(s) data and then go from there..

P

PartieHonteuse

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™
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

comparing values from one workbook with another workbook 3
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Cell values to an array, then array transpose to another workbook 8
Employee Schedule not plotting properly - chart type / data series not correct 0
Compare two different workbook sheet to show the difference in text 0
Comparing two workbooks - Excel 2010 - not using Add-ins 2
VBA to copy from one workbook into another 0
Query_Stringing data from field that have multiple results 0

Top