Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating Source List
We are using Excel 2003. My spreadsheet is using a data validation list. If I
change an item in a data validation source list, the worksheet still shows previously selected items. How can this be updated without manually going back and re-selecting the new source data? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating Source List
Are you saying that you want to change cells that previously had
aaa to bbb because you changed the data validation list from aaa to bbb -- Don Guillett Microsoft MVP Excel SalesAid Software "irish2171" wrote in message ... We are using Excel 2003. My spreadsheet is using a data validation list. If I change an item in a data validation source list, the worksheet still shows previously selected items. How can this be updated without manually going back and re-selecting the new source data? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating Source List
if something in the source list was titled johndoe and i changed it to read
johnd. anywhere there is a validation drop-down it still reads johndoe even though i changed the source to read johnd. "Don Guillett" wrote: Are you saying that you want to change cells that previously had aaa to bbb because you changed the data validation list from aaa to bbb -- Don Guillett Microsoft MVP Excel SalesAid Software "irish2171" wrote in message ... We are using Excel 2003. My spreadsheet is using a data validation list. If I change an item in a data validation source list, the worksheet still shows previously selected items. How can this be updated without manually going back and re-selecting the new source data? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating Source List
There's a sample file here that you could adapt to your workbook:
http://www.contextures.com/excelfiles.html Under Data Validation, look for 'DV0022 - Update Validation Selections' irish2171 wrote: We are using Excel 2003. My spreadsheet is using a data validation list. If I change an item in a data validation source list, the worksheet still shows previously selected items. How can this be updated without manually going back and re-selecting the new source data? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating Source List
debra......thank you for that. i downloaded it, and i see how it works. how
do get that macro into my existing spreadsheet? or can i? i'm not an advanced user and don't use many macros, and even fewer codes. "Debra Dalgleish" wrote: There's a sample file here that you could adapt to your workbook: http://www.contextures.com/excelfiles.html Under Data Validation, look for 'DV0022 - Update Validation Selections' irish2171 wrote: We are using Excel 2003. My spreadsheet is using a data validation list. If I change an item in a data validation source list, the worksheet still shows previously selected items. How can this be updated without manually going back and re-selecting the new source data? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating Source List
Try this on a copy of your workbook:
In the sample file, right-click on the Lists worksheet tab, and choose View Code Copy the code Go to your workbook, right-click on the sheet tab where your list is stored, and choose View Code. Paste the code there. In the code, change the sheet names and the range name for the list, to match the names in your workbook. The code replaces values in column B on the Data sheet, and you should change that if your data validation is in a different column. irish2171 wrote: debra......thank you for that. i downloaded it, and i see how it works. how do get that macro into my existing spreadsheet? or can i? i'm not an advanced user and don't use many macros, and even fewer codes. "Debra Dalgleish" wrote: There's a sample file here that you could adapt to your workbook: http://www.contextures.com/excelfiles.html Under Data Validation, look for 'DV0022 - Update Validation Selections' irish2171 wrote: We are using Excel 2003. My spreadsheet is using a data validation list. If I change an item in a data validation source list, the worksheet still shows previously selected items. How can this be updated without manually going back and re-selecting the new source data? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating Source Code in Charts | Charts and Charting in Excel | |||
Updating the source of a linked cell | Links and Linking in Excel | |||
Updating charts when data source is in a different file | Charts and Charting in Excel | |||
updating chart source after transposing rows | Charts and Charting in Excel | |||
updating source cells | Excel Worksheet Functions |