User Profile
lowdencaft
Copper Contributor
Joined Jan 30, 2026
User Widgets
Recent Discussions
Excel sheets that populate a drop down menu
Hello Is there a way to have a drop-down list of all the sheets in a workbook in a selected cell and the selected sheet from the list's data populates other cells in the first sheet? My goal : To easily see what machines are connected to a list of RJ45 wall points. In the workbook, there is 1 sheet that has a list of wall points . Each machine has its own sheet. Each machine sheet has lots of corresponding data that is not pertinent to the RJ45 wall point sheet. My goal is to select a cell next to a given wall point row in the RJ45 wall point sheet, that drops down a list of machines (that are all the machine sheets in the workbook). The selected dropdown list machine, will populate pre-defined adjacent cells with corresponding data from the selected machine sheet. Each cell in the MACHINE NAME column has a drop down list of the sheet names to select from. Once a machine is selected, the hardware names and model columns that are on the same row are populated with the corresponding data on the machine sheet. I have asked ChatGTP and Gemini AI to help ... without any success. Is this possible to do? Thank youCell 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 machines are connected to a list of RJ45 wall points. In the workbook, there is 1 sheet that has a list of wall point and each machine has its own sheet. Each machine sheet has lots of corresponding data that is not pertinent to the RJ45 wall point sheet. My goal is to select a cell next to a given wall point row in the RJ45 wall point sheet, that drops down a list of machines (that are all the machine sheets in the workbook). The dropdown list selection will populate pre-defined adjacent cells with corresponding data from the selected machine sheet. Each cell in the MACHINE NAME column has a drop down list of the sheet names to select from. Once a machine is selected, the hardware names and model columns that are on the same row are populated with the corresponding data on the machine sheet.
