Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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.
Steve
Attached Images
File Type: jpg 1.jpg (127.3 KB, 8 views)
Attached Files
File Type: xlsx Test.xlsx (11.7 KB, 6 views)
Reply With Quote
  #2  
Old 12-02-2019, 01:20 AM
ArviLaanemets ArviLaanemets is offline Filter Rows by Drop Down Selection Windows 8 Filter Rows by Drop Down Selection Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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, 6 views)
Reply With Quote
Reply

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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:10 AM.


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