Extract specific data from specific range contain specific text

[mohamedsayed]

Hello,

I need to know how i can extrat specific data from specific range but according to specific text .
colmns A1 , B1,C1,D1,E1 contain data i need to extract
exracting will be according to rows which contain " text "

I hope its clearly

Thanks alot

 

[beastman59]

When it is extracted, do you want it written to another worksheet, written to a text file, printed, or what?

 

[mohamedsayed]

I want to be written to another worksheet
Thanks for your reply

 

[beastman59]

Will it say " text" or what? What it contains is what you search for. If it will contain this or that, when either severa if statements or case statement will be needed. Is it only A2,B1,C1,D1,E1 or will it also go to A2,B2,C2,D2.E2 etc and if so, for how many rows down? You might look at http://www.mrexcel.com/forum/<wbr>excel-questions/692892-make-<wbr>shorter-new-post.html