Filter table based on drop down list and show on another sheet

Hi,

Can anyone help me to get a solution for attached sheet.
Looking to populate the filtered table data to show on main sheet based on the drop down selection.


Regards/Aju

Hello Aju
You could perhaps use the Advanced Filter facility. In the attached file I've created a macro to run this based on the Named Criteria range (Adv_Filter_Criteria) placed in the Filters tab. However, the "All" selection will not work with this, to show All you need to select a Blank from the combo boxes.

Hope this helps.
DBY

Thanks you DBY! There might be more staff count, in that case it is pasting the complete data! However was looking for the All functions as well! Is it possible by creating a userform? any other suggestions

Rgds/Aju

Hi
Not sure what this refers to:

There might be more staff count, in that case it is pasting the complete data!

Can you clarify?

DBY