Hi, attached is the file which has ur solution (Hopefully). it has some conditions which u have to follow else output will be wrong
Below are the conditions 1] It will get or clear total and subtotal for both the Halves.i.e. 2008-09 and 2009-10. 2]Do no click on any button more than once unless you change your data. i.e. new data. 3] data placing EXACTLY should be the same as in the sheet which u had provided. i.e. Month East west etc. should start from row 6 Next half should start from row 21. Note: if u keep only upper half that is ok but not same with the lower one. you can just place your next data and macro will everything. Regards, Hanumant ________________________________ From: Usha Negi <[email protected]> To: [email protected] Sent: Fri, 28 January, 2011 10:35:39 AM Subject: $$Excel-Macros$$ Subtotal Dear All, Good morning! I want to do subtotal on quarterly basis in the attached excel sheet. Could you please help me out on this? Is there any formula to do subtotal/total on quarterly basis Pls. see attached file. Thanks & regards, Usha -- ---------------------------------------------------------------------------------- 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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> 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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Usha Negi.xlsm
Description: Binary data
