I am new to the forum but I am having a challenge with finding a solution for my situation. I have an Excel (Office 365) file that is hosted in SharePoint. It is currently formatted with Drop down lists based off of a named range. The drop down list is applied to cells E9:AI889 on the "Attendance" worksheet. The data for the drop down list resides in the named range "Attendance_Codes" which is located on the "Data_Labels" worksheet cells B3:B44. The Attendance codes are only 6 digits long so everything is working and the whole process has no errors.
However, my supervisor wants it easier for the other Departments and would like the drop down list to the the Attendance Descriptions listed so people better understand what to chose. The attendance descriptions are in a named range "Attendance_Descriptions" that relates to cells C3:C44 on the "Data_Labels" worksheet. I do need the Attendance Code to be displayed in the cell after a selection is made due to the formatting of formulas to provide the attendance summary. The Attendance Description are also lengthy and some are upwards of 70 characters, which makes it impossible to see the whole definition. I have tried using Macros or VBA Code to change the width of the drop down for display, however Macros or VBA Code do not work in SharePoint.
So what options do I have left to use?
However, my supervisor wants it easier for the other Departments and would like the drop down list to the the Attendance Descriptions listed so people better understand what to chose. The attendance descriptions are in a named range "Attendance_Descriptions" that relates to cells C3:C44 on the "Data_Labels" worksheet. I do need the Attendance Code to be displayed in the cell after a selection is made due to the formatting of formulas to provide the attendance summary. The Attendance Description are also lengthy and some are upwards of 70 characters, which makes it impossible to see the whole definition. I have tried using Macros or VBA Code to change the width of the drop down for display, however Macros or VBA Code do not work in SharePoint.
So what options do I have left to use?
