Hi,
I am trying to think of how to do this loop activity in a macro. Let me try and explain...
I have two columns, the one on the left is populated with various lines of data which varies in number (usually about 50). The data in this column has been sorted and once sorted, blank lines have been inserted between sets of data. So going from the top of the column you might have say one populated cell then a blank then 3 populated cells and then a blank and then 5 populated cells and then a blank and then one populated cell.
What I need the macro to do is go down the column and in the right hand column, one the last cell of each section, sum the cells on the left.
So for instances example 1 would become example 2 (also see attached example in Excel File):ExamVBA.xlsx
Example 1
345
587
125
Eaxmple 2
345
587
125 Total 1057
The process would be repeated until the end of the data is reached.
Does that make sense?
TLP
Bookmarks