Create Multiple Dynamic Lists Based Off A Single Source Table

[RadheyaMansel]

Hi,

I have a list of Current Ingredients Used and I want to use this list in a variety of different workbooks. When I change the source, delete or add an ingredient, I would like all the lists to reflect the change.

I know there is a way with named ranges but that doesn't allow you to add or take out rows.

Just wondering what the best way to do this would be,

Thanks!

 

[Max1616]

Some options for you:
1. You could create a table in excel and reference the table column in a data validation list.
2. You could create a dynamic named range that grabs the entire column until the largest row with data. Example for Column A: =OFFSET($A$1,0,0,COUNTA($A:$A),1)
3. You could store your list in Access and create a link to the Access db that refreshes when opened.