PatRichard
New Member
- Joined
- Dec 29, 2018
- Messages
- 29
- Office Version
- 365
- Platform
- Windows
Greetings! I've built a dynamic drop-down using the method shown at Create Dynamic Dependent Drop Down. It works fine (see pic), and the data validation list source is set to =Data!$J$7#
I would like to update this so that the list excludes Sites['Site Name']. This would essentially build the drop-down to include sites other than itself in each row. Is this possible? What function would I use to exclude Sites['Site Name']?
I would like to update this so that the list excludes Sites['Site Name']. This would essentially build the drop-down to include sites other than itself in each row. Is this possible? What function would I use to exclude Sites['Site Name']?