Hi all, can anyone assist me in determining a formula that would add a cell to an existing named / drop down list used in an excel spreadsheet? For example, if I enter a value in cell A5. I want the formula to automatically add the contents of A5 to the named list (data validation drop down list) that is in another sheet.
Bookmarks