| 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
