Help for Excel filter

[devabharambe]

Dear Friends,

I need your help in creating sheet using advance filter. Excel details are as follows

Input data

There are various entries in various columns
Details indicates a particulars area
There are various areas in that entry

Output
Output should be in such way that if we enter name of particular area, corresponding details should automatically appear.

Please suggest how to create such sheet in arrange manner.

Devendra

[Mordred]

Hi devabharambe, let me know how this goes for you. Enter your Area and then click the Search button.

[Roger Govier]

Hi Devendra

Take a look at the attached workbook

I set up some named ranges, including a dynamic range for your data on Input sheet, so it will automatically grow as you add more data.

Please Login or Register  to view this content.

then the following macro was added to the button Extract on the Output sheet

Please Login or Register  to view this content.

[devabharambe]

Thanks for help me