Update columns with summation based on criteria in multiple sheets

[jayped]

Hello,

I'm not sure if this is possible and I have limited knowledge of macros. Here is what I want to achieve:

I have a Summary Sheet with a list of names and ID numbers vertically and each month of the year horizontally as columns - e.g Jul 2019, Aug 2019, and so on. I will then have a tab for each month with data. A new sheet will be added at the end of each month. In each sheet, let's use 'Sep 2019' for example, will have a column containing amounts, a column containing names, and a column containing ID numbers (Columns J,K & L). I want to be able to run a macro that updates the Sep 2019 column on the Summary sheet by looking up the ID number on the Summary sheet and summing all the amounts that occurred on the Sep 2019 sheet for that ID number.



Thanks!

 

[jayped]

Thank you. Can I put a range in there like C4 to O240?

 

[DanteAmor]

Try:

sh1.Range("C4:O240").ClearContents

 

[jayped]

Thank you. You have been a great help.

 

[DanteAmor]

You are welcome.