J
Jon
I have a worksheet with a structure of different levels,
e.g.
Lev1, Lev2, Lev3, Lev4 as the headings
I want to create an index of occurences of a particular
name on another worksheet in the same workbook. e.g.
Lev1 has the word DAVID in the column and on the same row
there are other names in different Lev headings. I want
the index to reproduce all lines in this structure where
DAVID is contained. I think its sort of a filter function.
I agree this is hard to explain. Let me know if you have
any ideas, or whether i should explain it better.
Thanks in advance
Jon
e.g.
Lev1, Lev2, Lev3, Lev4 as the headings
I want to create an index of occurences of a particular
name on another worksheet in the same workbook. e.g.
Lev1 has the word DAVID in the column and on the same row
there are other names in different Lev headings. I want
the index to reproduce all lines in this structure where
DAVID is contained. I think its sort of a filter function.
I agree this is hard to explain. Let me know if you have
any ideas, or whether i should explain it better.
Thanks in advance
Jon