Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 10-24-2006, 12:54 PM
zura04 zura04 is offline
Trouble With Data Validation And Filtering On A Dropdown
Join Date: Oct 2006
Posts: 1
Default Trouble With Data Validation And Filtering On A Dropdown

Hi all,

I need help! I created a dropdown menu using Data Validation and a dynamic range, so that anything typed into the range automatically appears on the dropdown.

The formula I used for this was a Defined Name of:

=OFFSET('Priority List'!$C$6,1,0,COUNTA('Priority List'!$A:$A),1)

Where C6 is the header cell of the column and I want the range to go on to the end.

What I want to know is how I can filter that dropdown so that when I select "A" from the dropdown menu, all the rows that do not have "A" in the C-column are hidden (like what happens with Autofilter). Is there any way to do this?

I am pretty new to the tough aspects of Excel, so please try to keep it relatively simple.

Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Filtering out CC's arzsupra Outlook 0 03-11-2008 05:55 PM
Trouble updating a form TomCaesar Outlook 0 11-29-2006 10:52 AM
contacts filtering bubba622 Outlook 0 05-01-2006 03:41 PM
Word Forms : Dropdown lists wferaera45 Word 0 04-06-2006 03:02 AM
Validating Dropdown box dammad83 Word VBA 0 03-01-2006 12:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:51 PM.

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