Results 1 to 1 of 1
  1. #1
    Join Date
    May 2005

    Unanswered: Extract details from another sheet based on a list value.

    On one excel sheet I have data copied from a pivot table in the type of format shown in the attached excel.

    In another sheet I have created a Data -> List of all names.
    When I choose a name from the list eg. ABN AMRO BANK, what I want is that the entire range (from A39 to F52) which contains data pertaining to the name be extracted and be shown near the list.

    What sort of formulas would help me in achieving this aim.

    I use Excel XP.


    Attached Files Attached Files

Posting Permissions

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