View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default combo box on a column

If you copy the combo box down a thousand or so rows, that will keep
you going for a while. It's not consistent with database optimization
guidelines, but that's one of the trade offs for using Excel as a
database! (Kidding, not scolding.) If you do it this way you're done,
and just have to remember to copy another thousand or so rows when you
finish the first thousand.