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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Watch MrExcel Video

Forum statistics

Threads
1,114,086
Messages
5,545,877
Members
410,711
Latest member
Josh324
Top