Quote:
Originally Posted by batman1
I gave you detailed instructions. That's enough.
|
Batman,
Moving passed my initial annoyance with your last, I followed your steps and modified the attached version 1.1 per your instructions. Yes, it works very well and very fast.
In the attached version 1.2 (posted earlier), I used three dictionaries. It also works fast and very well and, mentioning this only for others reading this, a little faster than version 1.1. I believe this is due to there is no looping to replicate the CountIf and CountIfs functions.
Ver 1.1 or 1.2 would not have been possible for me without your help. Thank you again.
P.S. Ver 1.2 is modified to disable the options for Duplicate Row and Copy Control ID when Create Family Relationship is selected.