Another way, Do filter on database ----> select all visible cells (Alt + ;) then insert row, it will insert row before all Sub Total's lines
Regards, Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Pehrson, Dave Sent: Saturday, February 26, 2011 9:09 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ SubTotal and Insert Req Thank you Rana, for your kind support. Is it possible to accomplish this with a macro as I hane many rows to deal with? Thanks Dave ________________________________ From: excel-macros@googlegroups.com To: excel-macros@googlegroups.com Sent: Sat Feb 26 01:45:23 2011 Subject: Re: $$Excel-Macros$$ SubTotal and Insert Req if u want to insert row after the subtotal line (i.e u are saying that you want to insert a blank row between the subtal line, and the next group.) 1-Right Click below the subtotal row, or on first row of below group 2-Click on insert 3-Select "entire row" 4-Click ok If u have any further question then mail me Rana Muhammad Sohail Pakistan On Thu, Feb 24, 2011 at 9:53 PM, Diamond Dave <dpehr...@walbro.com<mailto:dpehr...@walbro.com>> wrote: Team, 1'm looking for support with the "SubTotal" function in excel 2007 or 2010. I'm looking to insert a blank row between the subtal line, and the next group. Note: the subtoal line exists in column A. Any Ideas? Thanks for your support -- ---------------------------------------------------------------------------------- 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<mailto: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<mailto: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<mailto: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
