Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Posts
    174
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Spliting A List To Several on Different Sheets (Excel 2000)

    I have a long list, a log of events done by different people on different days sorted by days, then name, then events (for example, first colume: date, second colume person's name, third colume event). How can I use functions/formulas to separate this list into several sheets each showing only the log of one particular person, sorted by dates without a lot of empty rows ? (So if the entire list contains 900 records and three persons, then each sheet would have a list of average 300 records sorted by dates.)

  2. #2
    3 Star Lounger
    Join Date
    Nov 2001
    Posts
    342
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spliting A List To Several on Different Sheets (Excel 2000)

    Try Data -> Filter -> Advanced Filter -> and export to another sheet depending on the criteria you set.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2003
    Posts
    174
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spliting A List To Several on Different Sheets (Excel 2000)

    Thanks Ted. THe problem with filter is that it is not automatically refreshed when the list data changes. Anyway I can use a function/formula to accomplish that ?

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Spliting A List To Several on Different Sheets (Excel 2000)

    I would NOT separate the items into separate sheets: They are much easier to work with and to summarize with them all in one sheet. Just use fdate - filter-autofilter to "filter" the data in place to only "view" one person's data. You can sort on multiple items and if you use SUBTOTAL function you can get summary info of the visible data.

    Summary of all the data is easily done using pivot tables. You can also use criteria and the d-functions, as well as ARRAY formulas to get summary info.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •