Quick Google search got me the shortcut to look at the VBA and confirm my suspicions. So, at this point, the question is, is it even possible to reference those values from within a cell on the sheet? If not, then I'll have to learn the VBA necessary to format as I mentioned and display it on the sheet somewhere. I don't have a problem doing that, mind you, but it's a lot more involved than just referencing the data that is pulled up from the drop downs in-cell.
As it is, I may try to adjust the VBA code to work with the simpler "Organization" and "Person" worksheets as suggested by ArviLaanemets
|