Drop down list Update

[vivi]

Hi there, I have created a drop down list with our company grading system and
the user can choose from the drop down list to get the grade and the
department and the corresponding cost for that grade will be automatically
put into another cell.
However, our company changed the grade hierarchy, therefore I have updated
the drop down list but the ones that had already been entered in the data
entry tab has not changed automatically. As there are many people using their
own templates for this, is there anyway I can update this without changing in
the data tab?

Hope this make sense

Thanks a lot in advance

 

[Shane Devenshire]

Hi,

when you say data tab, are you referring to Excel 2007? Or do you have a
tab in your workbooks called Data? What type of drop down list do you
have - Form Combo Box, Control Toolbox combo box or Data, Validation list?

If you are using a Data Validation List, then is that list entered into the
Source box or is it a range in the spreadsheet?

 

[vivi]

Hi there thanks for your reply, sorry for the confusion, I am using Excel
2003, I actually have a tab in the workbook called Data. I use the validation
list, should i be using something else for the list? I am not familier with
the form combo box, etc.
Any ideas?
Thanks again for your help