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
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