Control dropdown box

  • Thread starter Thread starter Daniel Bonallack
  • Start date Start date
D

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
 
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)
 
Back
Top