Don't misunderstand me, Peco; I don't disagree. But in this case, the OP himself said he's still thinking about a VBA solution, you sneered mildly about reinventing the wheel and in defense of Funk I pointed out several reasons why people may want to do that. That's really all there was to it.
In Funk's case particularly, there may be good reasons why he'll need VBA in the long run. Your solution works well if he just needs to glance at the worksheet and see the latest "Done" proc identified for each block. But if he had needed (or if he ever needs) the summary of that information listed on a separate sheet, I think it can be done with formulae but it may be simpler to use VBA. He never said.
[Later:] I take back the second paragraph. I just looked at your solution (I only glanced at it before), and it deals with that question, better than my approach would have. I'll have to study it more closely to see how you did that.
(What is "OP", anyway?)
|