select special range

Hello,
I wonder if its possible to select the range (one row) with using "IF" declaration. I want to make a macro, which will select and copy the range IF in column B excel will find "name1". I think about something like this (but that doesn't work) : Range(IF in column B = "name1"; copy whole row except column A,B and the last one (last column is different in different files, I want not to select last column in founded row)

This assumes data in rows 1-10 and copied to sheet2 but can be tailored to suit your purposes. Btw no need to select.

Please Login or Register  to view this content.

thank you for you help!
but.. I changed my way of solving my excel problem - so I do not want your code now ( but in future rather yes ). Now I have another problem with macro, but I am not so fluent in English and I can't write what I exactly need