Pivot Table - Selecting layout/Source Data

keltic

New Member
Joined
Sep 3, 2002
Messages
20
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
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,109,540
Messages
5,529,434
Members
409,876
Latest member
Akash Yadav
Top