Excel Data Filter Drop Down list

[jma49]

I have two Excel spreadsheets in this workbook and am using 2007 for development. Sheet1 contains the raw data and sheet2 contains summary information about the data on sheet1. I wish to restrict the user's access to sheet1 but I would like the user to be able to apply filters on the data in sheet1 via some method on sheet2. I know I can set up combo boxes to achive this but I'm looking for a cleaner, better looking way to do it. I would like to have a drop down box, command button, check box, or whatever on sheet2 that when activated will display just like the data filter drop down on sheet1 for the respected column and give the users the selections just like the data filter dropdown. Is there a simpler way to accomplish this without having to rewrite all the excel code that already exist to support this data filter selection function?

 

[redneck345]

Check out this URL: Http://www.bettersolutions.com/excel/EGH188/LE431611612.htm:)

 

[jma49]

Thanks for the response but the htm is not there.

 

[redneck345]

I'm Sorry.......see if the one below works.

http://www.bettersolutions.com/excel/EGH188/LE431611612.htm

I just tried it.....

redneck345

 

[jma49]

New link works great. Thanks for your interest and sharing the code. It looks pretty neat but is not exactly what I'm looking for with the posted issue.