Hi every one,
I have one Excel sheet like this
<tbody>
</tbody>
Now if I want to make two other separate sheet in the same Excel file, instead of use copy paste, is there any VBA code can extracting data base on city from sheet 1 so that
Sheet 2 will be
<tbody>
</tbody>
Sheet 3 will be
<tbody>
</tbody>
Thanks,
I have one Excel sheet like this
Customer | Location | Sale |
A | city X | 2 |
B | city X | 4 |
C | city Y | 5 |
D | city Y | 7 |
<tbody>
</tbody>
Now if I want to make two other separate sheet in the same Excel file, instead of use copy paste, is there any VBA code can extracting data base on city from sheet 1 so that
Sheet 2 will be
Customer | Location | Sale |
A | city X | 2 |
B | city X | 4 |
<tbody>
</tbody>
Sheet 3 will be
Customer | City | Sale |
C | city Y | 5 |
D | city Y | 7 |
<tbody>
</tbody>
Thanks,