Ok I figured out the using two worksheets and naming a range in the
namebox and loading into dataValidation from Data on the menu bar.
=rangeName in the source.

Is there a way to set the combobox and dropdowns as the other sheets
grows? It seems that I missing that setting.


--
bwall
------------------------------------------------------------------------
bwall's Profile: http://www.excelforum.com/member.php...o&userid=26997
View this thread: http://www.excelforum.com/showthread...hreadid=402012