Making a list with Lookup function
 

Hi!

I am doing a Bowling stats, program

What i need to do is to find all female and male seperatly and created 2
seperate colums with their respective info beside their name...

Ex. Myself 125 154 34.56
Her 254 164 29.56

I need to find all myself and all her and put them in colums to make a stats
sheet....

Obviously! all Myself are Men's name and All Her are female names,

Sorry1 for my expression, if you dont understand what i mean i can forward
the program to you for veiwing

Making a list with Lookup function
 

Hi Yan,

I think that the simplest way to achieve your objective is using Autofilter
and then copy visible cells only and paste them to another worksheet.

To find these in Help:-
xl2007
For Autofilter: Lookup Autofilter-Filter Data in a range or table
For Visible: Lookup Visible-Move or copy cells and cell contents-Copy
visible cells only.

xl2002 (and I think xl2003)
For Autofilter: Lookup Autofilter-Filter a list
For Visible: Lookup Copy-Move or copy cells-Copy only visible cells

Regards,

OssieMac

"Yan" wrote:

Hi!

I am doing a Bowling stats, program

What i need to do is to find all female and male seperatly and created 2
seperate colums with their respective info beside their name...

Ex. Myself 125 154 34.56
Her 254 164 29.56

I need to find all myself and all her and put them in colums to make a stats
sheet....

Obviously! all Myself are Men's name and All Her are female names,

Sorry1 for my expression, if you dont understand what i mean i can forward
the program to you for veiwing