Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list Update
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list Update
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list Update
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 "Shane Devenshire" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update relevant sheet after selecting from a drop down list? | Excel Worksheet Functions | |||
Using Drop-Downs (ValidationList) to update a budget | Excel Discussion (Misc queries) | |||
Update Formula's based on drop down list value | Excel Worksheet Functions | |||
Text to Columns from drop down list update | Excel Discussion (Misc queries) | |||
Update Excel Data List for Drop Down use | Excel Discussion (Misc queries) |