Idiot
06-14-2010, 07:26 AM
I've came, I've learned, and You guys conquered my problems. I hope I can rely on you guys again and apologize for not contributing yet (still learning).
I suppose I'll get right to it. A month or so ago I came to you guys with this problem: http://www.vbaexpress.com/forum/showthread.php?t=32096
And you guys did great in helping me. Now the macro has to be done in a different way. For quick reference, say we have some data:
1 13 25 37 49 61
2 14 26 38 50 62
3 15 27 39 51 63
4 16 28 40 52 64
5 17 29 41 53 65
6 18 30 42 54 66
(sorry for the format, i forgot what to use (tableit or something))
Instead of doing the sum of A1:C3 for the first block values, then the sum of D1:F3, for the next, then A4:C6, etc until all is done as it was in the previous problem, I now have to do the sum of (A3,B2,C1) for the first block, then sum of (D3,E2,F1) for the next, then sum of (A6, B5, C4), and then sum of (D6, E5, F4). Again this is just quick reference, I attached a new dummy file that shows what the outcomes should be.
Just like before, I want the user to be able to highlight all the data that needs to be calculated and have the results display a few rows below. The reason for this is that the data that I get can be hundreds of columns and rows wide and long and doing this manually is incredibly time consuming.
The dummy file has the macro that uses the previous method. I hope it can just be modified to make it easier for you guys. If not, I apologize, I'm just lost again.
Thank you so much for looking out for the little guys like me.
I suppose I'll get right to it. A month or so ago I came to you guys with this problem: http://www.vbaexpress.com/forum/showthread.php?t=32096
And you guys did great in helping me. Now the macro has to be done in a different way. For quick reference, say we have some data:
1 13 25 37 49 61
2 14 26 38 50 62
3 15 27 39 51 63
4 16 28 40 52 64
5 17 29 41 53 65
6 18 30 42 54 66
(sorry for the format, i forgot what to use (tableit or something))
Instead of doing the sum of A1:C3 for the first block values, then the sum of D1:F3, for the next, then A4:C6, etc until all is done as it was in the previous problem, I now have to do the sum of (A3,B2,C1) for the first block, then sum of (D3,E2,F1) for the next, then sum of (A6, B5, C4), and then sum of (D6, E5, F4). Again this is just quick reference, I attached a new dummy file that shows what the outcomes should be.
Just like before, I want the user to be able to highlight all the data that needs to be calculated and have the results display a few rows below. The reason for this is that the data that I get can be hundreds of columns and rows wide and long and doing this manually is incredibly time consuming.
The dummy file has the macro that uses the previous method. I hope it can just be modified to make it easier for you guys. If not, I apologize, I'm just lost again.
Thank you so much for looking out for the little guys like me.