Hi again
Here is the link
https://docs.google.com/open?id=0B4mitJ-SIt9bV3JuWFZFaXI1ckk
Could it be the VBA in the file can be corrected to function or it is complete disaster? :)
regards
Hi
Thanks for your swift reply.
Would it be easier if I send you the file to have a look? You are right, different list based on specific rules shall become available in dropdown.
Probably my explanations how dropdown lists should work in column "E" is not completely clear.
I will try to...
In the worksheet “PB” range (“C14:C313”) contains drop down list “Account”.
In the worksheet “CA” range (“B3:B1000”) is dynamic List named as “Account”
In the same sheet “CA” range (“D3:D1000”) represents account rules assigned to each account
In total there are 8 rules as listed below...