Pivot Table - Selecting layout/Source Data

[keltic]

I have recorded a macro to create a pivot table but the current data/layout is hardcoded into the macro. The number of lines may increase on a monthly basis and the macro needs to be able to capture all the data.

Is there a way of telling the macro to find the last row and column of data to include in the layout ?

Or do I need to create an input box at the point where the macro selects the layout ?

Regards
keltic

 

[keltic]

Sorted.