ok so far so good.....only now I can't seem to get all the rows of
data to show up or the other colums. Only the first of the 7 columns
is showing up now. I'm sure I did something wrong. But it isn't
showing the sales rep's name anymore and that's great. I went ahead
and entered a blank line after each sales rep's group of data. Was I
supposed to do it after every entry?



The code uses the current region, an area of cells surrounded by a blank row
and a blank column, so perhaps that's where the problem lies. I assumed that
each of the 7 columns has info in it and there are no blank columns in
between them. Is that correct? If not, then that's the problem.

As far as the blank row, after each sales group is what I meant to say.

Cheers,
Socratis