Quote Originally Posted by austenr
I think a visual aid is needed here. Could you post a sample?
I cannot upload at the moment, but if you could go to this link, I posted a sample, how the excel file looks like.

I'll post the link on the next post. I didn't know I need to post 5 posts, to be able to include a link.

It has like 4 screen shots, i think the third one is the excel file, I need to sum all the products for each of the business. But there is a need to insert a new row so I could do autosum function. This is just a dummy data, on the actual one, all the customers will have the same amount of rows, and same businesses, and products.

Hope this clarify a tad
thanks in advance