hii this is jinal
can any one pls tell me how to use macro with pivot table.
what i actually want to do is that when i run a macro automatically all the data in the current gets selected & when i press the refresh button all the pivot table based on that data also reflects the changes.
thanks & regards,
jinal
