Change in list details for data validation | Excel forum

Hi Geoff

Thanks for your question

The following steps will create a dynamic range which will automatically resize according to the items in your list

Create a named range using Insert-Name-Define.

Give your range a name

In the refers to box type the following equation

=OFFSET($D$1,0,0,COUNTA($D:$D),1)

This uses the CountA function nested within the Offset function.The offset function specifies a start point of cell D1 and a finish point based on the number of populated cells in column D.

Hope this helps,

Regards

Stephen