List of Worksheets in a Drop Down
Автор: Excel University
Загружено: 2020-05-27
Просмотров: 16156
Описание:
Download File: https://www.excel-university.com/yt_q...
Blog: https://www.excel-university.com/blog
In this video, I'll answer a question I received from Sara about how to create a drop down with each worksheet name and reference it in a formula to retrieve values from the selected sheet. As this is Excel, there are a variety of alternatives to accomplish this. In this video, I'll demonstrate one such solution that uses a defined name, data validation, and the INDIRECT function. Plus, as a bonus, I'll demonstrate how we can dynamically generate the list of sheet names using Power Query. Thanks Sara for your question!
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
![Создание нескольких зависимых раскрывающихся списков в Excel [ЛЕГКО]](https://image.4k-video.ru/id-video/daCvyt9E8s4)
