Best approach to using a filter.

[Livin404]

Greetings, I completed a spreadsheet where I extrapolated from a database totals based on tons. These totals are on the same worksheet as the database. On that same database I have a drop down box where I can chose “Contingency”, “Humanitarian”, “Support”, and “All”. The drop down box begins at B2. The Totals from this database begins at K7. I am hoping I can identify totals based on the selection made within that drop down. I’m basically looking for a filter that will still keep my spreadsheet working properly. I’m trying to make it as easy as possible for the user to use a filtering process. I’m thinking a VBA with buttons labeled with the criteria. Thank you.

 

[fadee2]

Hi Livin404,

Assuming the sheet in question is sheet1, with headers in A1 to L1, the column containing criteria (“Contingency”, “Humanitarian”, “Support”, and “All”) is column B, and your dropdown box resides in Cell C3, then bind following code to a button on worksheet.

Worksheets("Sheet1").Range("A1:L1").AutoFilter Field:=2, Criteria1:=Range("c3")

hth...