Okay, so maybe it is the whole formula that I need to change.

On that Daily Tracker sheet there are anywhere from approx 700 - 900
entries daily. 350 - 500 of those will end up on the Invalid sheet.
What I am hoping to deo is get them as a single list with out all the
other stuff inbetween.

So, if I were to follow your advice, then I would end up with something
like:

Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description

Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description



Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description



Ticket # -- Rep's Name -- Description


Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description


So on and so forth. What I would like to have is:


Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description


Much easier to read, count, sort, analuse, etc.

If there is no way to do it, thogugh, I will bow to your expertise and
understand.

Thanx again for all the help!!


--
nevi
------------------------------------------------------------------------
nevi's Profile: http://www.excelforum.com/member.php...o&userid=33238
View this thread: http://www.excelforum.com/showthread...hreadid=555148