Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MACRO - copy rows based on value in column to another sheet
See your other thread
-- Regards Ron de Bruin http://www.rondebruin.nl "Mike" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MACRO - copy rows based on value in column to another sheet
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" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
Search for rows in one sheet and copy into another sheet based on customer id | Excel Worksheet Functions | |||
Copy rows from one sheet to another based on a cell value | New Users to Excel | |||
Copy rows of one sheet into mutiple sheets based on column value | Excel Discussion (Misc queries) | |||
MACRO - copy rows based on value in column to another sheet | Excel Discussion (Misc queries) |