Hi everyone. I've found threads that cover similar questions to the one I have, but none which touch upon exactly what I'm looking for. This is also the first time I've posted in here, so I apologize if I do anything incorrectly.
What I'm trying to do is create an additional column within Excel that shows the "Ultimate Parent" for each value in my data. Let's say I have a table that looks like this:
I want to create a new trigger column which shows the ID of each entity's "Ultimate Parent" (with Bank Headquarters 1, 2, and 3 being the "Ultimate Parents" in this example):
From what I've gathered looking around for any sort of help to this problem, the way this issue is resolved is through VBA since Excel doesn't have any sort of tree functionality. I am just okay when it comes to Excel, and have very little experience with VBA (even though I do have a coding background with SQL). I was wondering if someone could point me in the right direction to what needs to be done in order to get this new "Ultimate Parent" column...I've searched around a bunch of different sites and forums and haven't been able to find anything that works. Thanks in advance, and if there's anything I can clear up about my example please let me know.
What I'm trying to do is create an additional column within Excel that shows the "Ultimate Parent" for each value in my data. Let's say I have a table that looks like this:
I want to create a new trigger column which shows the ID of each entity's "Ultimate Parent" (with Bank Headquarters 1, 2, and 3 being the "Ultimate Parents" in this example):
From what I've gathered looking around for any sort of help to this problem, the way this issue is resolved is through VBA since Excel doesn't have any sort of tree functionality. I am just okay when it comes to Excel, and have very little experience with VBA (even though I do have a coding background with SQL). I was wondering if someone could point me in the right direction to what needs to be done in order to get this new "Ultimate Parent" column...I've searched around a bunch of different sites and forums and haven't been able to find anything that works. Thanks in advance, and if there's anything I can clear up about my example please let me know.
