Sum After Segmented Number Series in Column

[Gary]

Hello,

I hope someone can help me or point me in the right direction. I have a file that has three blank rows between each different storeroom number. I need to add totals to the second (middle) blank cell after every segmented number series under QTY, PRICE, and TOTAL; however, I need to have the flexibility to be able to pick a starting cell in any column, not just column B, C, and D (this is just one file we would use this for).

STORE
ROOM.....QTY......PRICE......TOTAL
005-29........1........33.00......33.00

Need total>...1........33.00.....33.00

005-2921......1........73.64.....73.64
005-2921......1........73.64.....73.64
005-2921......1........73.64.....73.64

Need total>...3.......220.92....220.92

020-1065......2.........4.06......8.12
020-1065......6.........4.06.....24.36

Need total>...8.........8.06.....32.48

Is there a macro that would do this? I've searched, but did not find one. I appreciate any assistance, thanks.
This message was edited by Gary on 2002-02-22 09:56
This message was edited by Gary on 2002-02-22 09:59
This message was edited by Gary on 2002-02-22 10:01

 

[Anne Troy]

Hi!

You will want to post your question in the correct forum. This is where people can test their signatures and things like that. Click on the link:

http://www.mrexcel.com/board/viewforum.php?forum=2&1830

and post your question there. Just copy/paste it. Then, I'll take a look and many others will too!

Welcome to MrExcel!