View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jason Morin Jason Morin is offline
external usenet poster
 
Posts: 63
Default Finding Source of DropDown Field

"Sales" is a defined name for a range where the source data is. Press Ctrl +
F3 or go to Insert Names Define. Look for "Sales" in the list and you'll
see the ranges it references in the "Refers To:" box.

HTH
Jason
Atlanta, GA

"blucajun" wrote:

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?