Sleeper: Copy rows from worksheet 1 to worksheet 2

[specops]

I need to copy rows form worksheet 1 on to 2 and delete some rows which contain a number 4 in cell E.

One problem is that column C have a (x) against one of five rows containing questions in row B. I need to copy only the corrosponding cross and question on to worksheet two.

[Demosthine]

Good morning.

Would you please post an example workbook so that we can better understand what you are trying to do.

Thanks.
Scott

[specops]

not sure how to attach example

[GTO]

Click on the Go Advanced button below the Quick REply area. Below the msg area is Manage Attachments.

Hope this helps,

Mark

[specops]

copy of workbook attached. I am trying to create an executive summery on worksheet two which only contains the "red" scored rows information.

[lucas]

There are some problems with your layout. The biggest being the merged cells. I dragged down your column A entries so it would follow the copy to sheet two. I did not address deleting rows in this example. We have to talk about the merged cells.

see attached

[specops]

i have reformatted the audit to remove merged cells and using a dropdown selection for the status, i remove the status column which had the x in it so now the code need to copy all the rows on to workbook tow that have a score of <4 in column C.

Can the rows be copied to the next bllank row on workbook two so i can create a header section.

[lucas]

Like this maybe: see attached

[specops]

That is great but why does it arrange the rows in reverse order on the summary?

[lucas]

Because of the order that they are copied in. You can add an index column and sort the sheet after the copy....see attached