I have a spreadsheet with column I where there is a lot of data.

I have the 1000 which is the sum of the 2x500 (bold)

The 2x500 are the sum of the data (first one is 200 =300 and second one is sum of 5x100)

I would need a VBA that would populate the formulas taking in consideration the end of the selections

Column I is going down to about I1000 and even more so doing this manually is long and time consuming

Is there a way to do this with VBA? As I have several columns like "I".

Thank you very much

1000 | sum of the 2 x500 |

500 | sum of the 200 and 300 below |

200 | |

300 | |

500 | sum of the 5x100 below |

100 | |

100 | |

100 | |

100 | |

100 |