| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter using VBA
Hi,
Is it possible to use VBA to filter a worksheet? ie press a button which will filter a worksheet so that only those rows with columnA = 'yes' are displayed? thanks for any help cheers |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
filter using VBA
Record a macro while doing it manually and you have it.
HTH. Best wishes Harald "confused" skrev i melding ... Hi, Is it possible to use VBA to filter a worksheet? ie press a button which will filter a worksheet so that only those rows with columnA = 'yes' are displayed? thanks for any help cheers |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
filter using VBA
Just to supplement, what you will do manually will select the top left cell
of your data in the header row and do Data=Filter=Autofilter select the dropdown in column A and select "yes" It isn't clear that you know how to filter manually - but if you do, then you can ignore this. -- Regards, Tom Ogilvy "Harald Staff" wrote in message ... Record a macro while doing it manually and you have it. HTH. Best wishes Harald "confused" skrev i melding ... Hi, Is it possible to use VBA to filter a worksheet? ie press a button which will filter a worksheet so that only those rows with columnA = 'yes' are displayed? thanks for any help cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
| Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
| filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
Linear Mode
