![]() |
|
#11
|
|||
|
|||
|
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 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Looking to copy select cells in table using dropdown list to paste to new table in another worksheet | CaptainRetired | Excel Programming | 18 | 01-04-2018 07:22 PM |
Use function to select another worksheet
|
eugeneradial | Excel | 2 | 04-27-2017 04:53 AM |
Select added value from dropdown menu, program output
|
Aleksm | Excel Programming | 1 | 01-28-2017 05:40 AM |
select a cluster of point from a range based on x and y values
|
sandcharles | Excel | 5 | 02-19-2015 06:15 AM |
Appending unique data from one worksheet to existing data on another worksheet
|
EdStockton | Excel | 1 | 08-06-2014 11:00 PM |