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.