In the attached workbook, I have a worksheet called "Storage_Info" that has a column entitled "Container Size" (which I have highlighted in yellow). Each cell in this column contains a Data Validation list that is associated with a formula that uses the INDIRECT function. The INDIRECT function refers to four Dynamic Named Ranges in the worksheet named "Input_2_Hidden", which refers to data in worksheets called "Inventory" and "Input_1_Hidden." The list works great, but it starts at the bottom of the list. I've tried using OFFSET to avoid this but it isn't working and I've spend a better part of a day trying to figure out how to make this work. Any suggestions? I've uploaded the Workbook but am not sure that it is attached. Thanks in advance!!!!!!!! If not, let me know.
Thanks,
Sandy
Bookmarks