ashleyuk1984
12-12-2013, 11:45 AM
Hi,
I've been stuck on this for a little while now, and just can't seem to get my head around it.
Basically, I have data that looks like this (changed some info due to confidentiality) - Pretend the RED values aren't there!!!.
http://www.ultraimg.com/images/KY2sQ.png
Basically, I want a macro that creates the RED values for me (subtotals each block separately), instead of doing it manually. I can't seem to work out a way of doing it?
A subtotal at the VERY bottom isn't required... Just the separate blocks of data :)
"RED" values aren't required either... It's just for illustration.
A simple understanding macro would be great then I can try to learn it :)
Thank you!!
I've been stuck on this for a little while now, and just can't seem to get my head around it.
Basically, I have data that looks like this (changed some info due to confidentiality) - Pretend the RED values aren't there!!!.
http://www.ultraimg.com/images/KY2sQ.png
Basically, I want a macro that creates the RED values for me (subtotals each block separately), instead of doing it manually. I can't seem to work out a way of doing it?
A subtotal at the VERY bottom isn't required... Just the separate blocks of data :)
"RED" values aren't required either... It's just for illustration.
A simple understanding macro would be great then I can try to learn it :)
Thank you!!