View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCreighton PCreighton is offline
external usenet poster
 
Posts: 6
Default Data Validation Update Validation Selection

Update Validation Selection I have been to www.contextures.com and downloaded
DV0022, this is exactly what I wish to achieve when a selection in the list
is updated the data file updates to the new description. The problem is when
I add a new item to the list it updates every blank cell in the data file
colum with the new value added to the list, I don't want it to update all
blank cells when new item added to the look-up list. Please help with what I
am doing wrong.