MS Excell Filter List Based On Cell Value

Hello
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"
Filter.xlsx
NiceMan331Asked:
Who is Participating?
 
Rob HensonFinance AnalystCommented:
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.
0
 
ProfessorJimJamCommented:
you can create a dependent drop-down list for this.  here is a tutorial on how to
0
 
NiceMan331Author Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.