Hello, I have a corporate org chart for which I am trying to write a macro. The Excel workbook is set up so that each company is in a unique cell. The subsidiary is one column to the right. For instance, I would like to return the values in the far right column for the data below. Thank you.
A B C F