Copy Rows to another Worksheet Based on a Condition

**patxlb** · 09-18-2009, 10:48 AM

I have created a worksheet which contains seven columns of data and many rows. I need to copy entire rows into nine separate worksheets depending on the data in column G.

I know nothing about VBA but have read enough to realize this is the way to go with this. Would someone point me in the right direction on how to set this up?

I've attached the file so you can better see what I'm talking about.

Thanks. Pat

**davegugg** · 09-18-2009, 11:04 AM

Try this:

Please Login or Register  to view this content.

**StephenR** · 09-18-2009, 11:04 AM

Try this:

Please Login or Register  to view this content.

**patxlb** · 09-18-2009, 11:36 AM

Thank you both so much. This works perfectly.

**Al53** · 02-03-2010, 05:17 PM

First off, thank you for what you do! I am self-taught (arguably by a pretty shoddy teacher), and am determined to figure *some* of this stuff out. I've come to this forum many many times to work through issues.

I have modified the code by DaveGuggs above to fit my workbook. It works great and is WAY simpler than the code I had clunked out. I need to make one small change- in the row where it copies and pastes the data to the new sheet, I would like to only copy the data in column A through E, not the entire row.

I tried a bunch of things, for example, in this row

Sheets("Data").Rows(i).Copy Destination:=Sheets(Sheets("Data").Cells(i, "G").Value).Cells(lngDestRow, 1)

I put in

Cells(I & "A", I & "E")

in place of

Rows(i)

But it returned an error 13, type mismatch. What do I need to put in to only copy columns A through E of row I?

Thank you much!
Al

**davegugg** · 02-04-2010, 11:48 AM

You need to start a new thread for this request. Post the code you are using and how it is not working for you.

**cambralenta** · 07-06-2013, 04:47 PM

Did you manage to copy only the data in column A through E in the macro?
I need the same code!
If yes, please send it to me (or post here).

Thank you

**jeffreybrown** · 07-06-2013, 04:57 PM

Hello cambralenta & Welcome to the Forum,

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.