Code to add up range when data range changes

[BJ5352]

Hi,

I've attached a sample of some data that is generated by code. I need code for a simple sum formula to be included in the cells I've highlight red. The problem is the length of each grouping of data will vary every time the macro is run.

Thanks for your help.
Brad

[jindon]

For the data provided.

Please Login or Register  to view this content.

[BJ5352]

Thanks for the quick reply, but sorry your code did not really work. It did put formulas in but they didn't add the columns below red highlighted cells.
I've tried to amend but was not able to.

[jindon]

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Am I missing something? I don't see any red cells.

[BJ5352]

The red cells are in the attached file in the header row above each grouping of data.

[BJ5352]

Thanks for this fix, just about there.

They are now adding up the correct columns and the first and second formula add the values below them. But the third and forth group of formulas add the values above them not below.

Are you able to fix this portion of the code?

[jindon]

Just looked at your file again.
Is this how you wanted?

Please Login or Register  to view this content.

[BJ5352]

Perfect well done jindon

Just what I was after.