I have a data set that has Farmer name in column A, Fruit in column B and Ready? in column C. I want to copy and paste the farmer's name based on the fruit they plant onto their designated sheet (for example, APPLE under the sheet named APPLE), but I only want they want has yea under the Ready? column.
I was wondering if anyone tell me what is the best way to do this in VBA that creates the new sheet and copy and paste the criteria that I described above.
I am very new to VBA and writing this on my own is total out of my league.
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
I was wondering if anyone tell me what is the best way to do this in VBA that creates the new sheet and copy and paste the criteria that I described above.
I am very new to VBA and writing this on my own is total out of my league.
Farmer | Fruit | Ready? |
A | APPLE | YES |
C | APPLE | NO |
G | APPLE | YES |
E | GRAPES | YES |
B | ORANGE | YES |
F | ORANGE | NO |
D | PEARS | NO |
H | PEARS | YES |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>