Row Labels | Growth% |
KASHMIR | -6.02 |
NORTH EAST | 5.11 |
HARYANA | 6.99 |
GUJARAT | 8.02 |
RAJASTHAN | 8.06 |
BIHAR | 9.58 |
U.P. | 10.46 |
A.P. | 10.79 |
DELHI | 10.80 |
UTTRAKHAND | 10.83 |
CHATTISGARH | 11.81 |
PUNJAB | 11.89 |
WEST BENGAL | 12.83 |
JHARKHAND | 13.21 |
JAMMU | 13.24 |
M.P. | 14.57 |
TAMIL NADU | 14.66 |
ORISSA | 15.08 |
KERALA | 15.24 |
MAH. (VIDHARBHA) | 15.82 |
TELANGANA | 16.00 |
HIMACHAL PRADESH | 16.02 |
KARNATAKA | 18.69 |
MUMBAI | 19.40 |
MAH. (PUNE BELT) | 21.93 |
Grand Total | 305.04 |
<colgroup><col><col></colgroup><tbody>
</tbody>
Above is the pivot table and following is the normal excel table.
F. YR. | L. YR. | T. YR. | GROWTH |
TOTAL 2014-15 | 525.37 | 594.01 | 13 |
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>
I need all pivot table data in another sheet whose growth (13%) is less than above table through vba code.
the output will be:-
STATE | GRWTH |
KASHMIR | -6.02 |
NORTH EAST | 5.11 |
HARYANA | 6.99 |
GUJARAT | 8.02 |
RAJASTHAN | 8.06 |
BIHAR | 9.58 |
U.P. | 10.46 |
A.P. | 10.79 |
DELHI | 10.80 |
UTTRAKHAND | 10.83 |
CHATTISGARH | 11.81 |
PUNJAB | 11.89 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Means the pivot table data compares one by one excel normal table and then paste it to another output table.
I need this kind of vba code......thanks