Simple macro help...
Posted by Cory on July 26, 2001 12:47 PM
I have a column containing groups of numbers. In between these groups is a blank cell. I need a macro that will go to each blank cell and sum the group above it, move onto the next blank cell and do it again, so on and so forth. Some of these groups only have one value in it (which is where I'm getting stuck). Here's an example of what I mean:
In each blank a formula would be inserted adding the number directly above it, even if it's only one number (like the lone 21 would be the sum of itself; 21)
Thanks for the help...