Is this a repetitive task? If not, you can use Data/AutoFilter, then copy the
displayed rows to the appropriate sheet, then go on to the next name.

Or sort by column B and copy a section at a time.

On Fri, 4 Mar 2005 18:05:02 -0800, Michael A <Michael
wrote:

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!