Dependant Combo boxes, filter and displayed data from another worksheet

Hi jindon - thank you very much for this. I cant open your file properly. I get an error, saying the file is locked for editing, can you please upload it again for me. One thing I would also like to add is that if I remove and add coloum headers on Filter worksheet, then data for only those headers is filtered where column headers match with column headers in data sheet. So if a user decides to change the order of columns on Filter worksheet or adds or removes a column headers then data for only those columns is displayed in Filter worksheet. Also when workbook is opened can all three combo boxes be prepopulated with all unique values. Thank you again.

Hi Jraj1106 - thanks for what uploaded, very good. I will make use use of your solution too, but I need to produce this in excel 2003. Thanks again.

Originally Posted by gsrai31

Hi jindon - thank you very much for this. I cant open your file properly. I get an error, saying the file is locked for editing, can you please upload it again for me. One thing I would also like to add is that if I remove and add coloum headers on Filter worksheet, then data for only those headers is filtered where column headers match with column headers in data sheet. So if a user decides to change the order of columns on Filter worksheet or adds or removes a column headers then data for only those columns is displayed in Filter worksheet. Also when workbook is opened can all three combo boxes be prepopulated with all unique values. Thank you again.

Hi Jraj1106 - thanks for what uploaded, very good. I will make use use of your solution too, but I need to produce this in excel 2003. Thanks again.

Hi there,

your help is required and would be appreciated. I intend to do the same thing with more data but need to show the three combo boxes in userform not in excel worksheet.

did the same with combox boxes in userform and followed your code but did not work. need your help.

Thanks