I maintain a Resource Tracker which includes multiple Resource Names and Vendors. Resources are added and removed on a daily basis.
I created a Forecast Tracker for each workstream to update on a monthly basis (total of 12 Workstreams). I'm trying to find a way of keeping both dropdowns 'Resource Name' and 'Vendor Name' up to date.
Is there a way the dropdown could pull information from a source sheet, such as the Resource Tracker.