LinkBack URL
About LinkBacks
Hi,
I am using a pivot table very frequently whose rows increase and sometimes decreases.Hence,I have to accordingly do the setup for pagebreak and has drag the fill handler towards the of end data available.
How this can be resolved with vba.
Thanx
Hi,
I am using a pivot table very frequently whose rows increase and sometimes decreases.Hence,I have to accordingly do the setup for pagebreak and has drag the fill handler towards the of end data available.
How this can be resolved with vba.
Thanx
Please attachment sample your requirement
Pls find enclosed in attachment.Currently in PT Sheet which is infact Pivot table whose page setup is A1:B8.When the data increases or decreases in data sheet ,the page setup in PT Sheet which once set remains there only i.e A1:B8.So,I want it to be dynamic with the increase or decrease in rows.
Sorry for the late reply I was very busy.
Try this
Please Login or Register to view this content.
Hi,
Its not working.I have used your code but when I increase the data the pagebreak does not changes.
Kindly see what is missing in the code.
Try this attachment file.
Last edited by sanju2323; 03-17-2016 at 01:42 AM.
Ok this now perhaps work.If possible can you mentioned the comment in each line of code you have mentioned for my reference.
I am marking this thread as solved.
Last but not least, can u make a pivot table with two different sheets based on condition which I have posted in a thread at >>http://www.excelforum.com/showthread...t=#post4339025
Thanx for your kind support.
Last edited by paradise2sr; 03-17-2016 at 04:41 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks