Entourage 2016 validating and copying link data
Since then, Microsoft has released new versions of Microsoft Access with each release of Microsoft Office.This includes Access 97 (version 8.0), Access 2000 (version 9.0), Access 2002 (version 10.0), Access 2003 (version 11.5), Access 2007 (version 12.0), and Access 2010 (version 14.0).The highlighted parts must be changed based on the location of your source data and the location you would like the drop down list to appear: Note the highlighted section must changed if your source data is not in Sheet1 starting from cell A1.
Microsoft Access 2007 also introduced File Attachment field, which stored data more efficiently than the OLE (Object Linking and Embedding) field.
The data for the drop down list will come from the range “=A1: A6” in the sheet “Sheet1”.
Note you must change the highlighted parts based on the location of your source and the location for your drop down list: In order to modify, add, insert and remove items from a drop down list created using data validation, you would have to follow 2 steps.
Again the first thing would be to modify the source data: Or for example lets say we want to remove “item 4”.
Again the first step would be to modify the source data: Step 2: In the next step we need to update the drop down list to accommodate for the changes made in its source. The code below must be copied to the sheet with the source data.