Avatar of NiceMan331
NiceMan331
 asked on

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
VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
NiceMan331

8/22/2022 - Mon
Professor J

you can create a dependent drop-down list for this.  here is a tutorial on how to
ASKER CERTIFIED SOLUTION
Rob Henson

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
NiceMan331

ASKER
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
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck