Pivot automation

[arnab0711]

Hi,
can we have a macro for automatically creating a pivot out of a worksheet,where in the organisation name will be in the row section,the logic of aging will be in the column section and sum of value in the data section.

[teylyn]

arnab, please do not create polls in the question forums. If you want to ask people's opinion about something, create a thread in the water cooler.

thanks

[DonkeyOte]

arnab0711, have you tried recording yourself creating the Pivot ?
this would I think point you in the right direction, no ?