Hi Mahesh, Pzl find the workbook.
I would like to ask one more doubt when i click the pivot table value (in the attached sheet summary)a new sheet is appearing. In that sheet all the amount columns are appearing in date format. Can you help me how to change get amount in number format and date in date format without changing manually every time. 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
Report.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
