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....?

I know some basic VBA, but not enough to do what I want.
So far, all I could figure out was how to find the last cell on a row within a range of rows. But I don't know yet how to perform a loop detecting the first and last rows of every block, and to use that to find the last cell for each.
I thought there must be a way for a pro to do that within a few lines of code. But if it is going to get too complicated, then maybe I should just forget about it.

(Changing the distribution of the input data is not a possibility)

Attached Files

sample.xls (39.5 KB, 14 views)