MACRO - copy rows based on value in column to another sheet

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!

See your other thread


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Mike" <[email protected]> wrote in message news:[email protected]...
> 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!
>

I'm with Ron... There is more than enough info in our two responses to
accomlish what you want. Ron's sight is great (lots of cool stuff there Ron,
I have sent lots of people to it for reference) and my code gives you a good
start.

"Ron de Bruin" wrote:

> See your other thread
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Mike" <[email protected]> wrote in message news:[email protected]...
> > 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!
> >
>
>
>