Multi-Level Data extraction interface

Hi Jaslake

This time I have a request which is very similar to my previous request; however this time I have few more conditions to add.

Hope you will be my angel again.

What Macro Should do:

On pressing ctrl+z on keyboard

It should bring up the dialog box with a section for column names(where I can pick and choose columns to have in the sheet) and beside this column a series of different column names with its unique values again to pick and choose(basically show all column sections with its unique values)

Just like you did in the attached sheet but this time instead of selected columns; it will be for all the column headers with its unique values and under each of these sections an option to select all and deselect all.

So the idea is to filter based on the selected columns and its unique values to an output sheet
just like you did last time. Just that it should be dynamic in terms of column names and the data under it.

Factors to consider:
1. The header names will always be in first Row
2. All the column header names are variables, so all these column header names could change anytime and the values under these columns
3. The dialog box that will be created should be movable. In the current attached sheet when you press ctrl+z the user interface dialog box that comes up is immovable; wondering if you can address that
4. Format of all columns wondering if you can keep it "General" or which ever you think is the best as columns will include text, numbers, and dates.

Note: The file will grow and both vertically(columns names change and new one gets added) and horizontally

As usual relying on your great macro skills. Hope I am making sense to you..

Kind Regards,

4Gurus