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"