Selecting rows within a range

[JCG]

Greetings:

I'm developing a macro that will select all project numbers for an
individual in our organization. I hope to have a program/function that will
look at the data and select all project numbers "Project Number1 thru Project
NumberN for an individual and list it in individual cells on a sheet within a
workbook for that individual.

The data I want to extract is in the first column and the proper
program/funcition would identify all Project Numbers that are between Project
number (Header) and Total according to the format of my data shown below:

Staff Member Name1
Project number (Header)
Project Number1
Project Number2
Project NumberN
Total

Staff Member Name2
Project number (Header)
Project Number1
Project Number2
Project NumberN
Total

Staff Member Name3
Etc...

I'm greatful for any response.

 

[Don Guillett]

Give both before and after layout

 

[JCG]

The raw data layout is shown in the original post (except there are no spaces
between the row "Total" and "Staff Member NameN").

The after layout would look like the following:

Staff Member Name
Project Number1
Project Number2
Project Number3
Project NumberN

Overall, I want the program formula to search for a specific staff member in
the raw data and show all project numbers associated with that individual
(those project numbers between "Project number (Header) and Total". Hope
this makes sense.

 

[Don Guillett]

data>filter>autofilter>filter on column>CUSTOM>does not contain Header>AND
does not contain total
assumes, as you said no spaces.

 

[JCG]

Thanks for your suggestion, however; after applying the filter, I still have
all the staff member names and every project number. I'm not sure if I
explained this clearly after reading other posts. I'll try one more time.

The raw data looks like what i show on my first post (however, without
spaces). I would like to extract the project numbers on a separate sheet in
a workbook for a specific staff member only. These project numbers are
between the header and the word total for each staff member. So, when i
enter in on the separate sheet, say Staff Member Name2, the output on that
sheet will be
Project Number1
Project Number2
Project NumberN

which are all of the the project numbers associated with that staff member.
Does this make better sence?

 

[Don Guillett]

Just add the other parameter AND

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

Thanks for your suggestion, however; after applying the filter, I still
have
all the staff member names and every project number. I'm not sure if I
explained this clearly after reading other posts. I'll try one more time.

The raw data looks like what i show on my first post (however, without
spaces). I would like to extract the project numbers on a separate sheet
in
a workbook for a specific staff member only. These project numbers are
between the header and the word total for each staff member. So, when i
enter in on the separate sheet, say Staff Member Name2, the output on that
sheet will be
Project Number1
Project Number2
Project NumberN

which are all of the the project numbers associated with that staff
member.
Does this make better sence?