Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between.........

's Computer Specifications

Have looked around on the posts and not found anything on this,

Can someone help?

thanks alot

Andrea

's Computer Specifications

How about getting rid of the blanks, then using the Excel subtotaling
functionality?

On Jun 7, 3:52 pm, "amorrison2...@googlemail.com"
<amorrison2...@googlemail.com> wrote:
> Have looked around on the posts and not found anything on this,
>
> Can someone help?
>
> thanks alot
>
> Andrea

's Computer Specifications

I really only want sum calculations.....I cant get rid of the line
because it's a report......

can you help please with a macro do this?

On 7 Jun, 21:17, Ken <krco...@aol.com> wrote:
> How about getting rid of the blanks, then using the Excel subtotaling
> functionality?
>
> On Jun 7, 3:52 pm, "amorrison2...@googlemail.com"
>
>
>
> <amorrison2...@googlemail.com> wrote:
> > Have looked around on the posts and not found anything on this,
>
> > Can someone help?
>
> > thanks alot
>
> > Andrea- Hide quoted text -
>
> - Show quoted text -

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
First non empty cell and non blank cell	danpt	Microsoft Excel Misc	6	25th Oct 2008 04:28 AM
Find First Non blank cell than find column header and return that value	Silver Rose	Microsoft Excel Worksheet Functions	10	30th Apr 2007 05:56 PM
Copy to first Blank cell in Colum C Non blank cells still exist be	=?Utf-8?B?VWxyaWsgbG92ZXMgaG9yc2Vz?=	Microsoft Excel Programming	2	8th Oct 2006 07:35 PM
Want to copy a cell down until it comes to the next nonblank cell, and then take this next nonblank cell until it comes to the next nonblank cell, and so on...	GretOgrady	Microsoft Excel Discussion	2	5th Jan 2005 09:29 PM
Repost- sort & sutotal like items	Lumpy	Microsoft Access Database Table Design	1	23rd Apr 2004 05:05 AM