creating a list from an existing list

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
try using 'Advanced filters' and choose the other worksheet as target
range
Click to expand...
...

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.
 
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.
Click to expand...


Hi Harlan
thanks for the addition. I'm alread so used to this 'feature' I forgot
to mention it
Frank
 
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
 
Back
Top