Good morning,
I am trying to use this reference to create an auto fill data validation.
https://www.extendoffice.com/docume...op-down-list-autocomplete.html?page_comment=1
It works great for a normal named ranged. However, it does not seem to work when I'm trying to reference a column from another table. This other table is using Power Pivot to bring in Active Directory users. Since users come and go often, I really would like to have a refresh whenever working with this workbook.
When I click on the validation for this column, I simply get the data validation formula and not the list of users from my other table. Example: INDIRECT(TableUser[displayName])
I'm still pretty green with VBA code so I sort of see what's happening here but not enough to change the code.
Is this possible to correct or am I out of luck?
Thank you!
Randy
I am trying to use this reference to create an auto fill data validation.
https://www.extendoffice.com/docume...op-down-list-autocomplete.html?page_comment=1
It works great for a normal named ranged. However, it does not seem to work when I'm trying to reference a column from another table. This other table is using Power Pivot to bring in Active Directory users. Since users come and go often, I really would like to have a refresh whenever working with this workbook.
When I click on the validation for this column, I simply get the data validation formula and not the list of users from my other table. Example: INDIRECT(TableUser[displayName])
I'm still pretty green with VBA code so I sort of see what's happening here but not enough to change the code.
Is this possible to correct or am I out of luck?
Thank you!
Randy
