Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation source field size and function. | Excel Discussion (Misc queries) | |||
Pivot Table -- Refresh Data in Field Dropdown Lists | Excel Discussion (Misc queries) | |||
Finding a link source. | Excel Worksheet Functions | |||
Duplicate values in Pivot table Page Field dropdown.. | Excel Worksheet Functions | |||
Finding source of linkied Database?? | Excel Discussion (Misc queries) |