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