Any help would be greatlyi appreciated.

I need a macro that copys rows on a spreadsheet to another spreadsheet based
on the value thats in the B column. For example, b4 has "RES" as the value,
so i want row 4 to go to the first available line on the RES sheet. If it had
"BOB" as the value, i would like it to go to the BOB sheet on the first
available line. I would like to be able to do this with the entire sheet.
Thanks!