...
After clicking the search icon (magnifying glass) in the VLB you will prompted to input your expedition number. The macros use this number to set the folder directory it will search. The folder directory/file structure should be consistent with other expeditions; otherwise, the macro will give you an error. Below is an example of the proper file structure. Note the underscore before the expedition folder.
VT:\IODP_Share\ALL things DESClogik_DESClogik_EXP371\Value Lists
...
- Exact Match Only and All Possible Matches Option (Callout 4). The Exact Match Only option will restrict all search returns to exact matches only. Unselected, the search returns the nearest matches allowing for extraneous characters before and after the user value. For example, with the Exact Match Only option deselected the user value radiolarian might return radiolarian and with or radiolarian marl. This search only returns the first match found. The All Possible Matches option will continue to search through a list and return all matches found within. The exact match feature can be turned on or off.
...
The macro specifically references the names of the "Value List Builder.xlsm" and "Value List Builder Scientist.xlsm" workbooks and the sheet "Paste Your Values Here". DO NOT CHANGE the names of the workbook or the first sheet. If you change these names, you can simply rename them the originals, or replace the workbook with a copy from the other two locations.
The file path is specific and the file structure of your expedition needs to follow the example given below. Note, that there is an underscore before the expedition number.
VT:\IODP_Share\ALL things DESClogik_DESClogik_EXP371\Value Lists
...