Thread: serach of dat
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
M.K[_2_] M.K[_2_] is offline
external usenet poster
 
Posts: 11
Default serach of dat

hi all

if i have the following coulma

file123 33 33 58
file124 23 34 36
file123.a 27 26 64
filees123 22 27 67
file345 23 44 36
file123 11 99 44


how i can make new sheet include the file which have 123 so result will be

file123 33 33 58
file123.a 27 26 64
filees123 22 27 67
file123 11 99 44

thank you