MACRO - Copy rows from a sheet based on value in B

[ZipLipZ]

Hey all, i appreciate all the help. here is my problem.

I need macro that will go through a sheet and copy entire rows over to there proper worksheet based on the value in the B colum. For example if in B4 the text is "RES" then i need it to copy the row to the next available row in the RES sheet. But if the text is "BOB" then i need it to be sent to the BOB sheet ont he next available row.

Any help would be great.. thankyou!

 

[Glaswegian]

Go with Norie's code. It was late last night and I don't think I was quite thinking straight.

Cheers Norie!

 

[hatemachine]

What would need to be changed if the value should only contain part of the word, so for his example he wants RES... so what if we wanted everything that started with R. In my case, I have a number followed by a description:

20 lname
20 fname
30 title

and i need everything that has the 20 in the cel to be on a sheet called 20.