Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making a "Filter" button or field
First off, this is a great group! I used your ideas about making an index
page with links to each of my UGGHHHH 60+ tabs! And this workbook is turning out to be a real winner here! The "sheets" below are all a part of one workbook. One Excel file. OK, I have one sheet where data is automatically "dumped" from a computer program. Let's call it "Layout 1". (Tab name) I have another sheet that populates directly from the Layout 1 sheet. Basically, an identical page, called 75%. In the heading of sheet 75% (next to the niffty "Return to Index" link) is a cell with the following "text". Click here to run '75%' filter (We need a seperate sheet listing any features that use 75% or more of the allowable tolerance) OK. I set up a filter to filter out any row that does not have "75% of Tolerance used" in a specified cell/column. And it works fine. I need to automate this for those who don't use Excel as often. (Most here do not.) I'd like to have a button, or a cell that does the trick. Preference would be . . . a cell. The text says . . . click to run filter. If the filter is run, the cell says click to cancel filter. Or it could be 2 cells. One for on, one for off. That would work as well. Note. The 'off' part is necessary because the Layout 1 sheet will sometimes be edited. I'd want the filter turned off before editing. A button would work as well, as long as it "goes both ways". Maybe a "Filter On/Off" toggle button!?! That would be outstanding. A "Filter On/Off" cell would be preferred. I know this is long. But I wanted to be sure the question was understood correctly. Thanks, Wayne |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making a "Filter" button or field
I'd suggest starting by recording a macro. Start the recorder and play around with the autofilter. The resulting code is fairly easy to work with and you should be able to design the filter you need and attach that macro to a button. -- William DeLeo ------------------------------------------------------------------------ William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256 View this thread: http://www.excelforum.com/showthread...hreadid=550446 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable Text on a Button | Excel Discussion (Misc queries) | |||
Q: Hiding a field button on a pivot chart | Excel Discussion (Misc queries) | |||
Pivot Table Comment Field | Excel Discussion (Misc queries) | |||
Pivot Tables..I give up... | Excel Worksheet Functions | |||
How do I setup a spin button in excel | Excel Discussion (Misc queries) |