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?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"vivi" wrote in message
...
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