Control dropdown box

[Daniel Bonallack]

In column A I have a list of companies, and I have a
dropdown box that refers to them. But I want to be able
to add companies to the end of the list, and still be
picked up by the dropdown box.

Is there any way to make the input range for that dropdown
box dynamic?
Is there anyway to make the input range refer to a named
range (which can be dynamic)?

Thanks in advance
Daniel

 

[Bob Phillips]

Daniel,

This is the formula that you need

=OFFSET($A$1,,,COUNT($A:$A))

You can plug this straight or create a named range for it. If you are using
Data Validation on another worksheet it must be a named range.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)