Summarizing from multiple worksheets

Hi,

I have four master sheets and one transaction sheet. From these, I have to generate a Summary report. I have written a macro to compile these. But this is taking quite a long time as after setting filter, it has to go thru all the rows in excel sheet for each of the conditions,

I am nos sure whether this is the right approach or can be bettered

I have attached the sample sheet & please help me in optimizing...

In actual, I have more than 300 running projects for more than 10 regions, each having more than 2000 transaction items.

PS: This is my first macro program & post

Please Login or Register  to view this content.

Thanks,
VB