Hi Bob,

For the code to work as posted, using the data given as an example
then column A would have to be in Column C, Column B would have to be
in Column A and Column C can be in any other column.

ie in practice my regional data is in column C, salesman data in
column A and data is in other columns

Regards

Michael