Copy and Paste Selected Values from Multiselect Drop-Down Lists

You can copy and paste multiple values and delimited search strings for reuse to or from any multiselect drop-down, lookup, hub or application search. You can also do this for spreadsheet or word processing applications such as Excel, Google Sheets, or Word.

Prerequisites: Before you copy and paste multiple values or delimited search strings for reuse, you must first add your values and delimited search string selections by completing the steps in one or both of these topics:

To copy and paste your selected values for reuse:

  1. On the Search Criteria grid, select all the values in the multiselect drop-down list that you want to include in the search and then click away from the multiselect drop-down list to close it.
  2. Click in the Add Value field.
    The Copy icon and the Delete All icon display in the upper right corner of the field.
  3. Click to copy all selected values from the multiselect drop-down list in any Vantagepoint search.
  4. Use the CTRL+V shortcut to paste the copied records or filters into one of the following:
    • A report, field, lookup, or any other multiselect drop-down list or grid field located in a different Vantagepoint hub or application search.
    • A spreadsheet or word processing application, such as Excel, Google Sheets, or Word.
    Conversely, you can copy records or delimited search strings for reuse from a spreadsheet or word processing application and then use CTRL+V to paste them into a multiselect drop-down list before running your complex search. The pasted values display with semi-colon and space delimiters.