We do use pivot table quite a bit, but my boss wants this info broke out by
territory. There is quite a bit of data in these reports and up to now I
have been doing a copy/paste to break this info down to the territory level.
I was hoping that there might be a more automative way to populate all of the
info to each tab by Sales rep.

Thaks any way for your help!!

"Jim Thomlinson" wrote:

Have you considered using a pivot table. They are often the ideal solution
for breaking infomration out of record sets...
--
HTH...

Jim Thomlinson


"RWilson130" wrote:

I have a report that I do every week and the data within this report changes
from week to week. Once I have all of the data for the State, I then have to
break out this information into a separate tab (Central, Dallas, etc). The
Sales rep is indicated within the data (R Wilson, J Doe, etc.). Let's say
that the tab named Central is associated with R Wilson, should I use an IF
Statement to pull over all of the data from the State level to the tab named
Central? If so, can you tell me how this is done? If not, can you help me?

Any help would be VERY MUCH APPRECIATED!!!

Thanks!

Rwilson130