Extracting data to a list
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Extracting data to a list

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi,

    I'm trying to run an accounts system for a club using excel. I have one sheet where I enter expenses, details, and codes...it looks something like this:

    code cost details
    AA 1.00 item 1
    BB 3.00 item 2
    AA 4.00 item 3
    CC 5.00 item 4
    BB 12.00 item 5

    I want to create a separate worksheet for each code, for instance worksheet AA would have the cost and details for the two items with AA code, and so on.

    I'm not sure what's the way to do this using excel - I've tried a simple VLOOKUP, but that only finds the first entry using each code.

    Any help would be greatly appreciated - I'm a real beginner at using the finding and referencing capabilities of excel.

    Thanks a lot,

    Nick Brown


  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


  3. #3
    Guest

    Default


    Select the Row with your codes then
    select DATA, Filter and Autofilter
    Then filter on each code and copy the results to another sheet.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    TO ADD TO THAT PASTE THE SELECTION ONLY


    Visable cells not just paste.

    Rdgs
    ==========
    Jack

  5. #5
    New Member
    Join Date
    Feb 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi Nick,
    You can use a pivot table here and put the CODE into page. This will put your codes in different pages in the pivot table.
    Eli

    [ This Message was edited by: Eli Weiss on 2002-02-21 23:41 ]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com