Copy Rows to Existing Worksheet Based upon a Cell Value

[sclasen24]

I have 3 worksheets with information for all offices for each Month Dec, Jan, Feb. I need to copy rows from each one of those worksheets and paste it to a worksheet titled PROC. Rows should be copied based upon the Processor they are assigned to in cell D.

[natefarm]

Can you give a description or attach an example of what the Proc sheet should like? If you're wanting the entire rows copied, then Proc would just end up being a combination of all rows in Dec, Jan, and Feb, so I don't know what you mean by "copied based upon the Processor they are assigned to".

[sclasen24]

I want to take all rows from Dec, Jan, Feb worksheets A1 to Bf1(could be more if I add more rows)and copy those to PRC worksheet and sort by column D (Processor. Then I need to insert a row to separate (Fill Black) so that I can paste rows A1 to Bf1 if they have "Setup, Needs, Conditions, Submitted, Resubmitted" in column BC sorting again by column D Processor and column BC. Example of what I want it to look like on example worksheetAttachment 285163

[natefarm]

This should get you a start. Be sure you have headings on PROC before running it.

Please Login or Register  to view this content.

[sclasen24]

I created a command active x button and pasted the code, I receive a compile error

[natefarm]

It worked when I ran it on your sample workbook, so you'll need to provide more info. What line did it break on, and what was the problem?

[sclasen24]

Can you send me the sample workbook back so I can see it?

[natefarm]

Here it is, but please look at my private message to you regarding this workbook, if you haven't already seen it.

[sclasen24]

Thanks for the private message... I sent u a couple After I downloaded the example I was unable to see the button you added?

[natefarm]

Oh, I didn't add a button. I was just running the code. You can add one and assign it to to the subroutine.