Set up your list in an Excel table, which is dynamic and expands as you add new data Define names for these tables to create a named range that updates automatically ... up-to-date This approach ...