It's really great. This is what I was exactly looking for. Thanks a lot Mr.
Hanumant.
Two things I want to have:
1. I want subtotal and total in different colour. Can we do it?
2. I have seen print preview of this sheet, it is also showing these two
boxes of add and delete
subtotal/total, can we hide them when taking print out?
With regards,
Usha
On Sat, Jan 29, 2011 at 4:56 AM, hanumant shinde
<[email protected]>wrote:
> 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
>
--
----------------------------------------------------------------------------------
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
