ExcelBanter - Selecting rows within a range

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?
--
Thanks in advance...j

"Don Guillett" wrote:

datafilterautofilterfilter on columnCUSTOMdoes not contain HeaderAND
does not contain total
assumes, as you said no spaces.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JCG" wrote in message
...
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.

--
Thanks in advance...j

"Don Guillett" wrote:

Give both before and after layout

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JCG" wrote in message
...
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.
--
Thanks in advance...j