creating a list from an existing list

[Guest]

hi!

is there a formula that can create a list from an existing
list for some specific creteria. so kind of an iteration.

so say in one sheet i have list with colums Name, Address,
Phone no.
Now i would like to pull out certain records(just Names,
not other columns)in another worksheet.

AutoFilter wont work as i have too many blank rows in the
list

i know this was posted earlier and m not sure if anyone
responded.

 

[Frank Kabel]

Hi
try using 'Advanced filters' and choose the other worksheet as target
range

 

[Harlan Grove]

try using 'Advanced filters' and choose the other worksheet as target
range

...

Note: copying advanced filter results to other worksheets requires making the
destination worksheet active then running Data > Filter > Advanced Filter
because Excel will only return data to the active worksheet. Make this a bit
convoluted.

 

[Frank Kabel]

Note: copying advanced filter results to other worksheets requires making the
destination worksheet active then running Data > Filter > Advanced Filter
because Excel will only return data to the active worksheet. Make this a bit
convoluted.

Hi Harlan
thanks for the addition. I'm alread so used to this 'feature' I forgot
to mention it
Frank

 

[Guest]

thanks for the reply. but i dont know why it's not working.
i ve a column of ph. no. and my criteria is all #'s with
area code 905. so i am entering 905*. but it hides the
complete list. am i missing something here.

thanks again