View Single Post
 
Old 05-03-2018, 07:54 AM
ShankedS ShankedS is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Oct 2014
Posts: 62
ShankedS is on a distinguished road
Default

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
Reply With Quote