I am trying to create an iterative macro for this workflow but I failed to get the results that I want.
Essentially, what this workflow is doing is making sure each family member who is listed as a "owner" owns every entity (i.e, "owned entity") in the dataset. For example, Family member 1 ("Allan & Sallie") under the Family # column owns only Green Co. at the beginning of the dataset but by the end of the workflow, this family member should own at stake in Blue Co and Red Co as well. So, the summarize tool tells you every owned entity in the dataset. Each family member should own each entity by the end of the workflow. I hope this makes sense.
Anywho, I need to do this process for every family member that is in the dataset but do not want to have to filter out and continuously create this tool chain if additional members are added. If there is a way to do this in an iterative macro that would be great as the number of family members is can go past 3+.
Can someone please help with this? Workflow attached.
Thank you for your help in advance.
