MS Excell Filter List Based On Cell Value

NiceMan331 used Ask the Experts™
plz look at the attached file
i have one sheet "Transactions"
i have to type accounting records
in cloumn "Parent Account" have to select one value
then , the next cell , child account should be filter based on related data as per sheet "Child"
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Professor JMicrosoft Excel Expert
Top Expert 2014

you can create a dependent drop-down list for this.  here is a tutorial on how to
Finance Analyst
That tutorial is great if each of your lists only has a few items and there are only a few lists to create.

I have written an article which will give the option for multiple items at 3 levels. See article here: Dynamic Data Vaildation

If you have any queries, please post a comment on the article and I will see if I can help.


Thanx Rob
the article is too long
i need more time to read it
because i didn't find in that sample file a similiar list which i mentioned here in my question
then plz i can post a comment there
thanx again

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial