ok - i think i got most of what i am looking for in the title!!

I have a workbook, i have data in rows - (cols A:CJ)

Loop cells (col E)-

get all rows with matching data in where the first 4 characters = ("XXXX") -

paste all of these into different wb, worksheet ( "FAR" )

then again for ("YYYY") etc....

can anyone show me some quick code that i can throw in???

note: the workbook is already open, and is referenced in the code already....

(reply to