| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to insert sum calculation at every second blank cell for data above in column F
Hi
As the subject says My data is like Column A Column F John 100.00 10.00 Total 110.00 Blank Row Smith 100.00 10.00 Total 110.00 Blank Row I have two blank rows between every part of my data, I need to insert a sum formula to sum all the above to the previous sum formula. I already tried the edit go to special cells and used the sum button but it inserted the formula in every blank cell for the column making my data wrong, I hope someone can help and I am being clear, Thanks so much Andrea |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert a blank column between each column in a data file | Excel Discussion (Misc queries) | |||
| Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... | Excel Programming | |||
| How do I create a Macro to sort data and insert blank rows & subto | Excel Worksheet Functions | |||
| Macro code to test for blank row and insert blank row if false | Excel Programming | |||
| insert a blank row after data changes in a column | Excel Discussion (Misc queries) | |||
![amorrison2006@googlemail.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
