Populate data for Summary

[omegaboost]

Dear All,

I have the table in worksheet LIST with data Date, Number, Description, Amount1, Amount2 that I'm going to fill and I want to have the summary based on the Number in Worksheet SUMM. So after I make change or update on worksheet LIST, I expect the data in Worksheet SUMM also update too.
Is it possible do it this thing with VBA? I attach the excel file for more details.

Thank you

Edo

[jindon]

I guess your result is not correct.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

Code goes into Sheets LIST module.

[omegaboost]

Dear All,

Thank you for your help, the solution is very clear and fit with my expectation.

Thank you

Edo

[jindon]

My code and the other one does different thing.

So which one?

[omegaboost]

Dear Jindon,

Your code is perfect for my problem.

Thank you

Edo

[jindon]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.