Automatically updating cells from sourcebook to link book in excel

The main advantage of dynamic drop-down lists is that you won't have to change the reference to the named range every time after editing the source list.You simply delete or type new entries in the source list and all of the cells containing this Excel validation list will get updated automatically!If for some reason you prefer a usual named range, then reference it using the OFFSET formula, as explained below.As you see, the formula is comprised of 2 Excel functions - OFFSET and COUNTA.This method of creating an Excel data validation list takes a bit more time, but it may save even more time in the long run.Select the entries you want to appear in your drop-down menu in an existing worksheet or type the entries in a new sheet.

; =

Leave a Reply