See if it helps http://excelpoweruser.blogspot.com/2011/07/creating-pivot-table.html
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhu Sent: Friday, July 08, 2011 6:08 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ ***Macros require to create Pivot Table*** Hi Friends, I required macros for the attached data (Base sheet) which I can download from my system. The Excel sheet contains Base sheet in which all the transactions are include (Both positive and negative value). We have to remove the entire negative transactions and create Pivot table as per the pivot sheet attached Pivot table: . All the values are linked from Balance column.(Not booked value) . Display -Classic Pivot Table Layout. . Subtotal not required . Pivot table to be placed in new sheet(right to the Base sheet) Thanks, Regards, Prabhu. -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
