#1
|
|||
|
|||
Filter Rows by Drop Down Selection
Hi, could you help me create a simple script to filter rows by two drop downs selections?
Rows to filters begin row 5. The two drop downs are located in cell A4 and B4. Hide all rows except for what has been selected from the drop downs. Keep filter settings saved last used. Your help is greatly appreciated. Steve |
#2
|
|||
|
|||
In attached workbook I added 2 sheets for possible solution.
On sheet Budget are 2 separate Tables. One for original budget info, and another for later adjustments. To get what you want, you simply set autofilter for AdjustmentMonth field in adjustments Table e.g. to 2018 February. On sheet SetUp you can select year. In another Table on SetUp sheet 1st of 12 months in selected year are calculated. This Table is a base for Data Validation List to select months in AdjustmentMonth field in Adjustments table (i.e. real entries in this field are dates like 1st of January 2018). I couldn't place amounts in Adjusted Budget part in table on Sheet1 (your original table), so I left them out. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Repeat Drop Down Selection | jhansrod | Word VBA | 2 | 06-11-2019 11:28 PM |
Drop Down Menu for Paragraph Selection | callasabra | Word VBA | 1 | 09-12-2018 02:25 PM |
Drop down lists and pulling data from worksheet based on drop down selection | cjoyce73 | Excel | 5 | 07-17-2017 07:40 AM |
Drop down list/ filter help with sharepoint | DB12345 | Misc | 0 | 10-25-2016 02:03 PM |
drop down menu that control filter on other column | massi | Excel | 0 | 08-24-2010 01:13 PM |