Forum Discussion
lowdencaft
Jan 30, 2026Occasional Reader
Cell drop list of workbook sheets
Hello Is there a way to have a drop list of all the sheets in a workbook in selected cells and the selected sheet from the list, populates other cells in the first sheet? I want to easily see what ...
Harun24HR
Jan 30, 2026Bronze Contributor
Use the following formula to a name manager then use that name to data validation list.
=TOCOL(TEXTAFTER(GET.WORKBOOK(1)&T(NOW()),"]"))See the below article for more details.
https://techcommunity.microsoft.com/discussions/excelgeneral/rename-cell-to-various-different-sheet-titles/4430814/replies/4431560