We can do the subtotal in one cell only.
Find the attached excel file for the solutions Manish Purohit Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world. _____ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of vivek agrawal Sent: 15 August 2009 11:28 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Help with formatting and subtotal Hi Attached is the solution to problem...... you just need to hide to column C. Hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Aug 15, 2009 at 1:34 AM, Cesar Delanoval <cdelano...@gmail.com> wrote: I have a simple table of banking transactions. Columns are as follows Column A = Date in MM/DD/YY format Column B = Empty Column C = Unit ID Column D = Empty Column E = Amount (numeric, 2 decimals) Column F = Empty Column G = Check No Column H = Subtotal On this sheet, the transactions are listed and sorted by date. There could be several transactions on a single date or just one transaction on a single date. I am looking for a way to Subtotal the column E (Amount) by date and show that Sub-Total on colum H (see attached sample which was done manually) As an addional formatting I also like to place like from column A to column H whenever the subtotal is calculated to visually show the group of transactions within that subtotal. see sample below Date Unit ID Amount Check No SubTotal 7/10/2009 5220 363.39 1083 7/10/2009 3103 222.25 6754 7/10/2009 5118 222.25 2508 7/10/2009 3102 211.88 1232 7/10/2009 3218 188.37 393 7/10/2009 3206 211.88 2704 7/10/2009 6211 188.37 0 7/10/2009 6221 195.00 785 7/10/2009 3220 363.39 414 2166.78 7/13/2009 4218 188.37 480 7/13/2009 3117 270.00 712 7/13/2009 4106 267.30 5026 725.67 7/14/2009 6227 188.37 2206 7/14/2009 6216 188.37 798 376.74 7/16/2009 6229 211.88 6285 211.88 7/17/2009 5110 222.25 613 7/17/2009 5229 211.88 3287 7/17/2009 6209 268.12 1061 702.25 The number of transactions varies so it is never the same. if anyone has a question, feel free to call me. Thanks --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
Sample_Subtotal.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
