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.
<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>
</tbody>
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.
Rest Rooms | Inspect | þ | ý | N/A | R | C | M | Notes |
Ceiling Lights | All lit. no broken/stained lens | |||||||
Fan | Operational and clean | |||||||
Floor | Swept & Mopped | |||||||
Light Switch | inspect for dirty and operational | |||||||
Mirror | Clean | |||||||
Paper Towel Dispenser | Operational and full | |||||||
Sink | Clean. Operational, not leaking, has soap | |||||||
Toilet | Clean. Operational, not leaking | |||||||
Toilet Paper | Has holder. Is full | | | |||||
Toilet Seat Gaskets | Has holder. Is full | |||||||
Doors | Clean. Freely open/close. Not sticking. | |||||||
Public Restroom | Nothing is stored in the restroom if its public.(mop, bucket, chemicals, etc.) |