Complicated macro/formula/updating in future

[Excel Me]

I'm creating this macro that will read a report and update a table on the next tab over with the sum of numbers. Is there a formula that will look at column A and B, if column A matches a certain "text" AND column B matches a different critera of "text", then look at column C, remember that number for those criteria and continue through the sheet looking and adding, else remember zero and continue adding?

Seems like a lot, wasn't sure. If not, then is there a way for me to sort and subtotal, but in such a way that the next time I need my table updated, I can run the macro and it will sort, subtotal, and read the new total even if it ends up in a different row because numbers are increasing?

ANY help us suggestions would be GREATLY appreciated. I've racked my brain for a bit now. Thanks!

 

[Excel Me]

if all else fails i will just create a new pivot table each time

 

[rudfaden]

If your range is not to large you can loop trough all the cells and compare each cell with an if statment.

 

[Excel Me]

My data set will increase exponentially and daily. I
I'm starting to think a pivot within the macro makes sense. Let me ask this, what are the, if any, limitations of a macro? How many steps can I include within one macro?

 

[rudfaden]

In theory you can make a macro as large and complicated as you want. However, the more calculations the more time is takes.