I have a single column of numbers (varying length) with blank cells randomly spaced. How can I select cells between two blank cells. For example if I have this:
1 1 3 2 7 1 2 2 5
I want to be able to add the numbers between the blank cells. Basically end up with a sheet like this after the macro is initiated, the sum of the groups being in the next column over:
1 1 3 2 7 7 1 2 10 2 5 7
Bookmarks