Pivot Table Macro

[mike760534211]

I am trying to write a macro that will start on the the cell and column entered from user input and loop number of times entered by user. When you enter the starting point it starts on the next row no the initial.

Example if you enter everything to start on B4 it actually starts on B5 then loops the correct number of times.

Please Login or Register  to view this content.

That is the code I have thus far. But can't seem to enter the correct code to get it to repeat. Any help would be greatly appreciated.

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

[mike760534211]

Thank you for this. I forgot to enter the code. Working out the bugs. But i have attached it below.

[mike760534211]

I have worked out a macro that will prompt for the first column & row of the pivot table reports that you want to extract. It will also prompt for the number of times to repeat so that you can start with any cell and will extract the amount you want automatically. The code is a little convoluted but works.

Please Login or Register  to view this content.