Find and Replace with multiple conditions problem.

Hrm, I tried that code in my sheet, and it still always only returns the first MH it finds, even if the adjacent cell doesn't say "Available". It looks like it should work, not sure whats wrong with it.

Chris

Basically what I'm trying to do is create a Schedule Generator. It works like this, when you run it, it pops up a userform that lists all the employees that work in my department, and it has a dropdown box beside each one. The dropdown box defaults to "Available" to signify that they're available to be slotted into the schedule. If you change the dropdown box to something other than available, it changes the corresponding box in the data sheet. The code then uses the data sheet to find available people and slot them into positions they're trained to do. I'm sure my workbook wont look too pretty to some of you pro's, I'm still new to excel, and trying to push myself to learn more with challenging tasks.

The part I'm trying to get working now is to get it to fill in the "MH" position on the schedule, with someone who is trained as an "MH", But if the first "MH" isn't available, I want it to select the 2nd one and put that person in that position instead.

Hope that clarifies things a bit.

Chris

I consider this a minor hurdle, the major hurdle I forsee with this little project is that once I get all off the critical positions slotted into the schedule (MH, QA, and 2 Printers) I want to eventually have it slot in the rest of the available operators into random locations on the schedule

Can anyone else possibly help me with this?

Thanks,
Chris

Nevermind, I figured out the problem,

Please Login or Register  to view this content.

Should have been

Please Login or Register  to view this content.

Thanks a lot for the help, it is very much appreciated.

Chris

Actually, it created a new problem. The code works great as is unless it doesn't find any matches, in which case it should output a textbox that says "No MH Found" but that currently never happens, if it doesn't find anything that matches both criteria, it just does nothing and makes field "B29" blank, any ideas how I can fix that?

Ok, in this workbook, if you hit the generate schedule button, it will bring up a userform with all the employees. If you change any of them from "available" to anything else, it should exclude them from the schedule. Currently if you change "Connie-Lee" and or "Shannon" from available to something else, it should skip over them and search for a different printer via the Data sheet Column D, if it can't find them, it should then search for a backup, Via the data sheet, Column E, if it can't find one there, it should output a textbox that says "No printer found" same for MH and QA, but once it completes the loop for the primary positions, it never searches for a backup, and never outputs a textbox if it can't find the appropriate people. I hope that explanation made sense.

When I try to run that, I get a Run-time error '6'
Overflow

I downloaded your newest sheet, and I get the same error when I try to run it. I just open the file, and click "Generate Schedule" and then leave all the values normal (all employees "Available") and hit the generate button on the userform. I immediatly get an Error: Runtime Error '6': Overflow. When I click debug, it highlights the find section of code in the Find_QA function

Please Login or Register  to view this content.

when I hover over the strFind variable, it says strFind = Nothing, which seems normal, and FindString = QA, which also seems normal, I'm not sure why its hanging up, should there be a range attached to the With Sheets("Data").Cells ?

That works perfectly! I'm not sure what the difference in syntax was, but that last change made it work exactly they way I wanted, finally. Thanks so much for your help

Chris