Thanks to everyone in advance for your help on this.

I need to copy all the rows on a sheet based on the value thats in the B
column, and i need to paste them into the sheet that coresponds to that value
(for example B10=RES/ i need to send this row to the "RES" sheet. Furthermore
i need it to paste it to the next available row, and not copy over ones that
are already there.. can anyone help with this please? Thank you!