 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2004Table Question
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.  SignatureRegards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- > Good Day > [quoted text clipped - 8 lines] > > Thanks in advance!! 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! > 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 [quoted text clipped - 18 lines] > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.659 / Virus Database: 423 - Release Date: 15/04/2004 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! > Good Day > [quoted text clipped - 8 lines] > > Thanks in advance!! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.