Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Filtering information (XP)

    The attched is a dummy sheet based upon a poorly developed worksheet containing hundreds of lines. What the end user wnats is to be able to filter based upon the User ID in order to show the information which has been inputted by various users. For example by filtering based on user 1645004 rows 1 to 8 would show; filtering based upon164005 would show rows 19-36.

    This is more than just using the filtering option in Excel. Is what the user wants possible? VBA code is fine.

    Using Access is not possible.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Filtering information (XP)

    The worksheet looks like a report from a database system exported to Excel. This format is not intended for or suitable for filtering. If possible at all, you should use the database to filter and display data.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Filtering information (XP)

    Alternatively, export the data from the database in a table format instead of in a report format. You can then use the filtering options built into Excel.

  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: Filtering information (XP)

    Insert a header row above your current Row 1 (add headers, fro example A1 = User ID, B1 = Full Text)

    In the new A2 enter:
    =IF(ISNUMBER(SEARCH("Page :",B2)),RIGHT(B7,7),A1)

    Copy A2 down the column. add an Autofilter

    Now you can filter on Column A for the User ID desired

    Steve

  5. #5
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filtering information (XP)

    Entering the formula in A2 gives me "User ID" not the number I would have expected. Copying down gives me USER ID down the column. When I AutoFilter there are no numbers to select from.

  6. #6
    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: Filtering information (XP)

    Did you follow all the directions?

    This is the file Iget from your example

    Steve
    Attached Files Attached Files

  7. #7
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filtering information (XP)

    Missed a space between Page :. Thanks this is really helpful.

Posting Permissions

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