Hello Kevin, I assume it is more complex than exposed in my first post..

To answer your questions:

-> "A1" is ALWAYS "B7". Table headings always start at B7.

-> Some datas include discount.
Indeed, discount should be included in the calculation as followed
On each row including datas, UNIT PRICE (column F) - 15% (example of discount rate) * Qty (column G) = TOTAL (column I)

-> "Total For Fruits" (in row18) do always accompany the Fruit sub-total

-> No need to delete the final total line in a macro

Thank you so much for your help!
Warmest regards.
Thierry