Hi JazzKult,

Many thanks again for your reply! The code provided works like a charm, however I wonder if it is possible to embed it with the Macro Button, so the calculations (both the Total Sales and Breakdown of sales) would be executed once when clicking on such button.

Best.