Table Question

  • Thread starter Thread starter Me
  • Start date Start date
M

Me

Good Day

I have a table (a1:n2400) that retrieves info from 7 days of the week
(different files). Once I filter out the blanks I have all the info I need,
unsorted.

What I'd like to do is sort each of the records in the table on a seperate
sheet, sorted by which Rep is associated with the record.

I think this is easy, I just don't know how to do it.

Thanks in advance!!
 
Sounds like a possible candidate for a Pivot Table and the Show Pages Option to
me, but depends on the layout of your data. Can you post a small excerpt of
your data (Text only please), so we can get a feel for what it is you are
looking at.
 
Thanks for looking, Ken


DATE DEAL # CUSTOMER NAME CONF # VERIFIER REP PP? TO? FINAL
STATUS SPIFF XSPIFF TIME

3/1/04 GK 1 SMITH 321654987 LERE Allen Maier Y JJ 349 APP 12:37 PM
3/1/04 GK 2 JONES 123654789 HIM Andreaka Davenport 698 APP 12:38
PM
3/2/04 CM 1 MARTIN 258741369 Allen Maier 798 APP 12:39 PM
3/3/04 GL 1 LOWE 963258741 Anthony Persuad DEC 12:39 PM
3/4/04 GK 1 HALL 963256587 Carlo Bullaro 698 APP 12:40 PM
3/5/04 GK 1 HIBBERT 524554785 Carlo Bullaro 698 APP 12:41 PM
3/5/04 GF 1 LONG 211455523 Arthur Guaylupo 369 APP 12:41 PM



Boy, I hope that send like I think it will.

Basically, I'd like to draw from this table, each REP'S sales, and place
them in the allotted space on the other sheet.

I hope this is enough info, please let me know if it's not, I'll try to
supply more.

Thanks again!
 
Thanks for looking, Ken


DATE DEAL # CUSTOMER NAME CONF # VERIFIER REP PP? TO? FINAL
STATUS SPIFF XSPIFF TIME

3/1/04 GK 1 SMITH 321654987 LERE Allen Maier Y JJ 349 APP 12:37 PM
3/1/04 GK 2 JONES 123654789 HIM Andreaka Davenport 698 APP 12:38
PM
3/2/04 CM 1 MARTIN 258741369 Allen Maier 798 APP 12:39 PM
3/3/04 GL 1 LOWE 963258741 Anthony Persuad DEC 12:39 PM
3/4/04 GK 1 HALL 963256587 Carlo Bullaro 698 APP 12:40 PM
3/5/04 GK 1 HIBBERT 524554785 Carlo Bullaro 698 APP 12:41 PM
3/5/04 GF 1 LONG 211455523 Arthur Guaylupo 369 APP 12:41 PM



Boy, I hope that send like I think it will.

Basically, I'd like to draw from this table, each REP'S sales, and place
them in the allotted space on the other sheet.

I hope this is enough info, please let me know if it's not, I'll try to
supply more.

Thanks again!
 
Back
Top