So frustrated! Please help!

[Please HELP!]

I need to change the names in the drop down list that appears when clicking
an arrow next to the name Burdett, but I cannot figure out where that list is
stored at. Selecting a name from this list causes other cells to change unit
counts etc.
MODEL ADVISOR MSRP GROSS
Burdett 0.00
0.00
0.00
0.00

 

[Jacob Skaria]

Check out Data>Validation>Validation criteria to see the typed entries/cell
range/named range. If that is a named range ; type the name in Name box. (Box
Just above cell A1; which displays the selected cell address. OR go to
Insert>Name>Define to see the named range cell references

If this post helps click Yes

 

[Atishoo]

sounds like your cell uses data validation.
select data then validation drop down should be set to list with the range
of the list options in the box below