Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 12-01-2019, 09:10 PM
baes10 baes10 is offline Filter Rows by Drop Down Selection Windows 7 64bit Filter Rows by Drop Down Selection Office 2007
Advanced Beginner
Filter Rows by Drop Down Selection
Join Date: Dec 2017
Posts: 33
baes10 is on a distinguished road
Default 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.
Attached Images
File Type: jpg 1.jpg (127.3 KB, 3 views)
Attached Files
File Type: xlsx Test.xlsx (11.7 KB, 2 views)
Reply With Quote
Old 12-02-2019, 01:20 AM
ArviLaanemets ArviLaanemets is online now Filter Rows by Drop Down Selection Windows 8 Filter Rows by Drop Down Selection Office 2016
Join Date: May 2017
Posts: 518
ArviLaanemets has a spectacular aura aboutArviLaanemets has a spectacular aura about

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.
Attached Files
File Type: xlsx BudgetUpdates.xlsx (17.9 KB, 1 views)
Reply With Quote

Thread Tools
Display Modes

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
Filter Rows by Drop Down Selection 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

All times are GMT -7. The time now is 12:30 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd. is not affiliated with Microsoft