View Single Post
 
Old 09-29-2013, 05:45 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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?)
Reply With Quote