Drop down list Update


V

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
 
Ad

Advertisements

S

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?
 
Ad

Advertisements

V

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top