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

serach of dat
 

Make sure you have a header in row 1, then DataAutofilterSelect custom from
column A drop down list, choose Start with option with value "file123"

Regards,
Stefi

€žM.K€� ezt Ã*rta:

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