Quote Originally Posted by mvidas
I think this could use a major overhaul, depending on exactly what you're doing Is there any way you could post the workbook here?
Yeah, this could use a major overhaul...I'm going to attempt to make a formula for this instead of this function. And I'll post a dummie workbook because my work would not be happy with me posting real documents online, but I'm sure no one will have a problem with a dummie workbook.

I'm guessing you're not using this function as a worksheet function (otherwise a lot of this wouldnt work).
Actually I am using this as a worksheet function. But it is placed in 2332 cells and each time the function is calculated it is searching through 10 sheets. That's why it is taking so long.

In the dummie workbook:
-Total Productivity Rate sheet is where the calculations are made
-Employees Names sheet holds the dynamic Named list of the sheets with the employee names
-Employee sheets hold the data
-Sheet1 is where I am testing formulas. The closest one (IMO) is where I'm trying to use the intersection method using Defined Names.

If you are a formula guru, I could use your help. This is pretty difficult.
Please take a look at this (ANYBODY ) and tell me what you think. You could even tell me to give up, as long as I know people are actually looking at this.

Thanks again