Hello, I am working on a spreadsheet/workbook and was wondering if anyone could help with my issue. I have a drop down in column 1, it'll then give me a drop down list in column 2, which autofills column 3, and finally gives a drop down list of coding in column 4. I have my drop down/look up's in another sheet, yet when I try to add a new row, the formula is messed up/ doesn't allow the correct option to selected. Is there a way to make this formula constant throughout my display sheet. As you can see, when I have selected 2. Superstructure in my new row, the filtered list is only allowing me to select from what is currently being searched for in filtered list 1 in sheet 2. I can post the link to the excel doc & if anyone could have a look that would be appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Dropdown lists & new rows
- Thread starter krepm123
- Start date
-
- Tags
- drop down new row lookup
Similar threads
