Funk, I have a notion about how to find out using formulae. But I'm a little hazy on how that information is best presented. That is, I can see a running column down the same page that says (for example) "Block1.Proc2", and then a bunch of blank cells and then "Block2.Proc4", and so on down the page, so that the eye will be caught by the cells that have writing in them and the rest of those cells are blank.
But if you want them in a separate worksheet as a consecutive list, I expect it's possible—I've done that sort of thing—but it's a little kludgy. VBA would be the more obvious choice, but then VBA does you no good unless you know how to write programs—and if you knew how to do that you wouldn't be how to do it in VBA. So I guess the next question (unless you want to learn VBA) is how you want this information presented....?
|