SelectingCopying only relevant data across worksheets

I got 7 differen products. One on each worksheet on the same Worbook
I manufacture different batches a day of a product (several times a day). I count the bad batches and when the following batch is extremely bad I need to reject the whole run, for regulation purposes.

On the colums I got the numer of bad batches
On the rows Run1 Run2...differnt runs I do a day. The number of runs can
vary depending on the day.

I color in green the number of bad batches but when there is an extremely bad batch the cell is not coloured. Then I want to get rid of tha whole run (row). Meaning that if the row has a cell that is not colored then the row must be deleted. And obviously if all I got all the cells to end up in green on ta particular raw then I NEED to keep that row.


The first row is row 11 so A11 B11 C11 and D11 are the first cells on the row.

A B C D
12 11 09 05
.
.
.....
33 20 10 04
11 25 15 08


In the example above, the runs that i had to get rid of were on:

row01 (extremely bad batch = 05)
row15 (extremely bad batch = 04)
row27 (extremely bad batch = 08)


Finally I need to combine (copy all the rows with green cells from all the 7 worksheets to the the summary worksheet) all the data.

Thanks


OK I would like first to brake it into chuncks. the first task is to remove the rows that do not get green color. See before picture. Then only keep the rows that have all green cells. Thanks

Please Login or Register  to view this content.

Hi miguelram

I don't see it...perhaps others do. I'd recommend you post a workbook that demonstrates what you have and what you'd like it to be. Then explain how you get from what you have to what you'd like it to be.