automate the Macro :
- Choose the "Market/channel" from the drop-down list in cells B3 and B4 of the "Breakdown" Sheet
- Copy the range D3:R3 until the last values
- Paste the results into another "sheet"
- Return to the "Breakdown " sheet and choose the next "market/channel" from the list.
- Copy the same range
- And repeat the action until the last market/channel in the list is used
