Hello,
I have a workbook where I want to copy specific row data based on the value of a cell in a column. Below is from my workbook. The goal is anytime there is an "x" in header "R", then the cell values from columns "A", "B" and "I" are copied onto a new sheet called "ROCC". Same thing goes for column "C" and "M. Copied to sheets called "CLCKIT" and "MERCH".
For below the columns are standard A-I
Thank you.
[TABLE="width: 897"]
<colgroup><col width="123" style="width: 92pt; mso-width-source: userset; mso-width-alt: 4498;"> <col width="367" style="width: 275pt; mso-width-source: userset; mso-width-alt: 13421;"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;" span="3"> <col width="37" style="width: 28pt; mso-width-source: userset; mso-width-alt: 1353;" span="3"> <col width="391" style="width: 293pt; mso-width-source: userset; mso-width-alt: 14299;"> <tbody>[TR]
[TD="width: 123, bgcolor: #D9D9D9"]Rest Rooms[/TD]
[TD="width: 367, bgcolor: #D9D9D9"]Inspect[/TD]
[TD="width: 68, bgcolor: #00B050"]þ[/TD]
[TD="width: 68, bgcolor: #EA3F32"]ý[/TD]
[TD="width: 68, bgcolor: #9BC2E6"]N/A[/TD]
[TD="width: 37, bgcolor: #8EA9DB"]R[/TD]
[TD="width: 37, bgcolor: #8EA9DB"]C[/TD]
[TD="width: 37, bgcolor: #8EA9DB"]M[/TD]
[TD="width: 391, bgcolor: #D9D9D9"]Notes[/TD]
[/TR]
[TR]
[TD="width: 123, bgcolor: #FFFF66"]Ceiling Lights[/TD]
[TD="width: 367, bgcolor: transparent"]All lit. no broken/stained lens[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="width: 123, bgcolor: #FFFF66"]Fan[/TD]
[TD="width: 367, bgcolor: transparent"]Operational and clean[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #FFFF66"]Floor[/TD]
[TD="width: 367, bgcolor: transparent"]Swept & Mopped[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="width: 123, bgcolor: #FFFF66"]Light Switch[/TD]
[TD="width: 367, bgcolor: transparent"]inspect for dirty and operational[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #FFFF66"]Mirror[/TD]
[TD="width: 367, bgcolor: transparent"]Clean[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="width: 123, bgcolor: #FFFF66"]Paper Towel Dispenser[/TD]
[TD="width: 367, bgcolor: transparent"]Operational and full[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #FFFF66"]Sink[/TD]
[TD="width: 367, bgcolor: transparent"]Clean. Operational, not leaking, has soap[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="width: 123, bgcolor: #FFFF66"]Toilet[/TD]
[TD="width: 367, bgcolor: transparent"]Clean. Operational, not leaking[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #FFFF66"]Toilet Paper[/TD]
[TD="width: 367, bgcolor: transparent"]Has holder. Is full[/TD]
[TD="bgcolor: transparent"]
[/TD]
[TD="bgcolor: transparent"]
[/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #FFFF66"]Toilet Seat Gaskets[/TD]
[TD="width: 367, bgcolor: transparent"]Has holder. Is full[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="width: 123, bgcolor: #FFFF66"]Doors[/TD]
[TD="width: 367, bgcolor: transparent"]Clean. Freely open/close. Not sticking.[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #FFFF66"]Public Restroom[/TD]
[TD="width: 367, bgcolor: transparent"]Nothing is stored in the restroom if its public.(mop, bucket, chemicals, etc.)[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]
I have a workbook where I want to copy specific row data based on the value of a cell in a column. Below is from my workbook. The goal is anytime there is an "x" in header "R", then the cell values from columns "A", "B" and "I" are copied onto a new sheet called "ROCC". Same thing goes for column "C" and "M. Copied to sheets called "CLCKIT" and "MERCH".
For below the columns are standard A-I
Thank you.
[TABLE="width: 897"]
<colgroup><col width="123" style="width: 92pt; mso-width-source: userset; mso-width-alt: 4498;"> <col width="367" style="width: 275pt; mso-width-source: userset; mso-width-alt: 13421;"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;" span="3"> <col width="37" style="width: 28pt; mso-width-source: userset; mso-width-alt: 1353;" span="3"> <col width="391" style="width: 293pt; mso-width-source: userset; mso-width-alt: 14299;"> <tbody>[TR]
[TD="width: 123, bgcolor: #D9D9D9"]Rest Rooms[/TD]
[TD="width: 367, bgcolor: #D9D9D9"]Inspect[/TD]
[TD="width: 68, bgcolor: #00B050"]þ[/TD]
[TD="width: 68, bgcolor: #EA3F32"]ý[/TD]
[TD="width: 68, bgcolor: #9BC2E6"]N/A[/TD]
[TD="width: 37, bgcolor: #8EA9DB"]R[/TD]
[TD="width: 37, bgcolor: #8EA9DB"]C[/TD]
[TD="width: 37, bgcolor: #8EA9DB"]M[/TD]
[TD="width: 391, bgcolor: #D9D9D9"]Notes[/TD]
[/TR]
[TR]
[TD="width: 123, bgcolor: #FFFF66"]Ceiling Lights[/TD]
[TD="width: 367, bgcolor: transparent"]All lit. no broken/stained lens[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="width: 123, bgcolor: #FFFF66"]Fan[/TD]
[TD="width: 367, bgcolor: transparent"]Operational and clean[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #FFFF66"]Floor[/TD]
[TD="width: 367, bgcolor: transparent"]Swept & Mopped[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="width: 123, bgcolor: #FFFF66"]Light Switch[/TD]
[TD="width: 367, bgcolor: transparent"]inspect for dirty and operational[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #FFFF66"]Mirror[/TD]
[TD="width: 367, bgcolor: transparent"]Clean[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="width: 123, bgcolor: #FFFF66"]Paper Towel Dispenser[/TD]
[TD="width: 367, bgcolor: transparent"]Operational and full[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #FFFF66"]Sink[/TD]
[TD="width: 367, bgcolor: transparent"]Clean. Operational, not leaking, has soap[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="width: 123, bgcolor: #FFFF66"]Toilet[/TD]
[TD="width: 367, bgcolor: transparent"]Clean. Operational, not leaking[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #FFFF66"]Toilet Paper[/TD]
[TD="width: 367, bgcolor: transparent"]Has holder. Is full[/TD]
[TD="bgcolor: transparent"]
[/TD]
[TD="bgcolor: transparent"]
[/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #FFFF66"]Toilet Seat Gaskets[/TD]
[TD="width: 367, bgcolor: transparent"]Has holder. Is full[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="width: 123, bgcolor: #FFFF66"]Doors[/TD]
[TD="width: 367, bgcolor: transparent"]Clean. Freely open/close. Not sticking.[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #FFFF66"]Public Restroom[/TD]
[TD="width: 367, bgcolor: transparent"]Nothing is stored in the restroom if its public.(mop, bucket, chemicals, etc.)[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="width: 37, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]