Is it possible to use the value in cell A1 to filter the values in B1:B10? I am trying to use a user input to automatically set the auto filter rather than require the user to click the filter arrow and choose the filter value thay want. Thanks in advance.
John, this might work for you. This assumes your criteria is in cell A1 (what you want to filter for), and your data is in column B starting in row 2. You don't want to start your data in row 1, since row 1 may get hidden (along with your criteria cell) if it doesn't equal the criteria value.
This updates anytime you change the criteria in cell A1. It even shows all your data if you change the value in A1 to nothing (blank).
Please Login or Register to view this content.
Paul, thanks for the reply. Were would I put this? Is it like running a macro? Would they have to push a button for itt o execute? Thanks.
Open your worksheet, press ALT+F11 to open the vba window.
Expand the branch for 'VBA Project (your workbook name)' until you see 'Sheet1', 'Sheet2', 'ThisWorkbook', etc.
Double-click on the sheet that you want to apply the auto-filtering, and in the right-hand window paste the code I provided. You can then close the VBA window to return to your worksheet.
This code works on the worksheet's SelectionChange event, so you don't have to press any buttons or run any macros manually. Whenever you change the value in cell A1 it will update the auto-filtered data in column B.
JohnGuts
You are carrying this conversation with numerous members over at least two different formus, wasting the time of 3 (to date) forum members. Before posting, read the rules of either forum, and ask your question in one forum only.
http://www.mrexcel.com/board2/viewtopic.php?t=265557
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks