Repeating Worksheet Change Event on Different Ranges

**Tanooki** · 12-22-2014, 07:54 PM

I have this code that will update the "Monthly Subtotal" on row 16 whenever data in cells on rows 10-14 are changed. It is working fine. What I would like help with is taking this code and applying it to calculate data in rows 18-22 and return the "Monthly Subtotals" for that set of data in row 24. The format is identical and the data is simply shifted down a number of rows. I already have changed the references in the code that is currently working on rows 10-14 but don't know how to incorporate it into the original worksheet_change code. I've attempted to do so but am getting erratic behavior as the syntax is not correct. If anyone would be willing to help cut and paste and make any adjustments to make this functional it would be greatly appreciated. Here is the code and I've attached a sample workbook as well.

Please Login or Register  to view this content.

**watersev** · 12-22-2014, 08:32 PM

hi Tanooki, basing on your code:

Please Login or Register  to view this content.

**Tanooki** · 12-22-2014, 09:43 PM

Thank you very much Watersev. I didn't expect a reply so quickly. I am going to attempt to add the third batch of data to the code tomorrow. I may have a couple more questions if I have issues. Anyhow a sincere thanks again for your help.