Copy and paste a list

You can copy a list to paste into another system, copy a list which opens in Excel, and you can paste a list into Vernon CMS.

Copy a list

With a list open in List Manager, go to the Edit menu and click Copy Table with Headings.

If you don't want to include headings, click Copy Table without Headings.

Copy a list to Excel

You can copy lists to Microsoft Excel. Vernon CMS will only copy the fields you have selected in List Manager, and the thumbnails for each record.

With the list open in List Manager, go to the Edit menu and click Copy to Excel with Images.

If you don't want the images, click Copy to Excel without Images.

Paste a list into List Manager

You can copy lists from outside Vernon CMS and paste them into List Manager if the records in the list have identifying information that exists in Vernon CMS. When you paste, Vernon will search for each record. So it's a good idea to paste information that is unique to the record, like the accession number or System ID.

With List Manager open, go to the Edit menu and click Paste.

If there is more than one record that matches your data, for example a related record, a member record, or one with a similar accession number, the Authority Options window will open so you can select the right one.

Pasting only the exact records you want

If you have a list of System IDs, you can use a formula in Excel to prefix the IDs with this search key:

ID\

Using the search key with your System IDs means that Vernon will paste those exact records and the Authority Options window won’t pop up.

  1. In Excel, in a column next to the column containing your System IDs, enter this formula (where A2 is the first cell of the column containing your IDs):
    =″ID\″&A2

  2. You will get this result (where 23 is the data in the first cell):
    ID\23

  3. Copy and paste (or drag) the formula to the remaining cells in the column.

  4. Copy and paste this data into List Manager.

Pasting all possible matches

If you want the system to automatically select all the possible matches instead of asking you to choose, you can use paste the list ‘quietly’. With List Manager open, go to the Edit menu and click Paste List Quietly.