Calc - conditional validation list

Hi.
Please, help me. I want create a validation list on column ‘Account’ (P) that should appear a valid one to the Date (H) only account (B) that is not closed (column E in blank) or that the Date (H) is in period between Start (C) and End (D).

In this way, in Account (P) for the ‘TransacID’ 1 must appear only “Visa2” and “bank2”; for ‘TransacID’ 2 should appear “Visa2”, “bank2” and “cash2” because Date (H) of this transact is in period of this account; for ‘TransacID’ 3 should appear “Visa2”, “bank2” and “cash3” because Date (H) of this transact is in period of this account. Find file attached.
ConditionalValidation.ods (20.5 KB)

could dedicate a cell range, for each line, depending on H,
but almost an Anti-pattern - Wikipedia

probably more effective to get inspired from existing examples, like Monthly Budget and Expense Record » Extensions,
or Personal Budget Template » Extensions,
etc … Topics tagged budget

@fpy Thank you. However, this solution is not applicable for me. I will continue searching…

which one ? there are dozens of them :thinking:

your pattern seems to be more of a form, with the help on some macro to fill the gap …
(and maybe more base than calc)