filtering lists?

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I am registering people for a convention. Data is entered
in the Registration Worksheet. Each registered name has up
tp three additional people registered represented only by
their badge name. Each of these badge names can volunteer
to lead meetings or be a convention volunteer. I want to
list these people on the volunteer worksheet. The
registration will be around 2000 and the people
volunteering will be about 100 so I want to avoid all the
blank rows.

SHEET ONE - REGISTRATION (What I Have)
LAST FIRST BADGE-1 MTG-1 CONV1 BADGE-2 MTG-2 CONV-2
Smith Bill Bill 1 John 1
Ball Mark Mark
Decon Jim Jim 1 Beth 1

SHEET TWO - VOLUNTEERS (What I Need)
MEETING LEADERS
LAST FIRST BADGE-1 BADGE-2
Smith Bill Bill
Decon Jim Beth

Convention Volunteers
LAST FIRST BADGE-1 BADGE-2
Smith Bill John
Decon Jim Jim


Any help would be appreciated,
Thanks, Bill
 
If you enter the names, instead of a "1" in the volunteer columns, you
can use an Advanced Filter to extract the data, either to separate
worksheets, or to adjacent lists on the same sheet.

There are instructions here for filtering to a different worksheet:

http://www.contextures.com/xladvfilter01.html#ExtractWs

For the criteria area to extract Meeting leaders, leave the heading cell
blank, and in the row below, enter a formula that refers to the first
row of data in the main table. For example, with data starting in row 5:

=OR(Registration!D5<>"",Registration!G5<>"")

On the destination sheet, add the headings that you want to extract:
LAST FIRST MTG-1 MTG-2

You can turn on the macro recorder as you filter the data the first
time, then run the macro to update the lists.

If you'd like a copy of the sample sheet that I created, let me know.
 
I'd appreciate a copy of that sample sheet. Thankyou for
the help. Bill
-----Original Message-----
If you enter the names, instead of a "1" in the volunteer columns, you
can use an Advanced Filter to extract the data, either to separate
worksheets, or to adjacent lists on the same sheet.

There are instructions here for filtering to a different worksheet:

http://www.contextures.com/xladvfilter01.html#ExtractWs

For the criteria area to extract Meeting leaders, leave the heading cell
blank, and in the row below, enter a formula that refers to the first
row of data in the main table. For example, with data starting in row 5:

=OR(Registration!D5<>"",Registration!G5<>"")
Click to expand...
 
Back
Top