View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
blucajun blucajun is offline
external usenet poster
 
Posts: 23
Default Finding Source of DropDown Field

I have a quote form that was created by a former employee and I need to edit
a couple of drop down fields to add new and delete old sales reps. I have
never worked with drop down fields but after reading through this forum, I
understand that I can find the source when I go to Data Validation -and
look under the box for Source. However, rather than showing a range where
the list is contained, it shows =Sales. I don't find any other cells in the
worksheet with Sales Reps, nor do any of the other worksheets contain this
info. I just don't know where else to look. Can anyone point me in the
right direction?