View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Arkansas Lady Arkansas Lady is offline
external usenet poster
 
Posts: 4
Default Combo Box and Sorting

I have a spreadsheet that I want to put a combo box on each row. The user
selects a treatment type for each item in the row. You can sort the
worksheet and the combo box will stay with that row. However, it's still
linked the the same cell. For example, if it is linked to N2, I can sort the
spreadsheet by name. The combo box may now be in N100 but it is still linked
to N2. Is there a way to link it after you sort the spreadsheet.
--
Arkansas Lady