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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy columns and paste with blank column between 5
Paste in column B using Last row of either column B, C or D. 10
Macro will copy formula instead of value 6
Excel Help to copy information from one row at a time to another sheet 1
Copy a range instead of just one row but with condition 8
copy to another sheet based on column value 4
Find a value in a sheet and replace it with another value if it matches 8
Want code to copy to ABOVE row 22 column A on sheet 1 10

Back
Top