roll up/consolidate rows with addition

Hello,

I'm working on writing some macros and I have a little trouble. My first thought was to use If then statements but since it appears you can not do if then then then then... statements I'm not sure how to accomplish my task with out a 200 line macro. I know scripting dictionaries could easily accomplish this but those are out of my skill set.

I am trying to roll up/consolidate rows based on a value in a certain column remaining the same. The column I am referring (A) to is actually a concatenation of 4 different columns.I added column (B) so I could easily pick these out of 200,000 plus rows. The tricky part is that there are a few columns that need to be summed up when they are rolled up/consolidated. These columns are (I), (J) and (K). The rest of the columns will remain the same so summing them up isn't required.

There are a small percent that are like this maybe 2 or 3% of 200,000+.

I've attached an example...Please let me know if you have any questions.

Soooo like if column (B) equals 1 then do a pivot table? I'm not sure how to write that in a Macro... I'll have to do some playing around. The trouble i see if there are countless lines that do not need to be "rolled up" and some instances where multiple lines need to be rolled up.


I'll play around and see if I cant get it working.

Also another issue is that I would like for people other than myself to run this on the fly.

When I try a Pivot Table I can not add the columns that do not need to be added as they have more than 16384 Items. Any thoughts?