LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Validation source field size and function. Dudedad Excel Discussion (Misc queries) 1 June 20th 07 07:47 PM
Pivot Table -- Refresh Data in Field Dropdown Lists howard Excel Discussion (Misc queries) 1 December 22nd 06 03:02 PM
Finding a link source. Richard Buttrey Excel Worksheet Functions 5 October 12th 06 11:10 PM
Duplicate values in Pivot table Page Field dropdown.. [email protected] Excel Worksheet Functions 1 June 28th 06 03:45 AM
Finding source of linkied Database?? mattylance Excel Discussion (Misc queries) 1 June 25th 06 10:44 PM


All times are GMT +1. The time now is 05:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"