Clone Results to a New Sheet

It is possible to keep all structures on the original sheet and display the filtering results on a new worksheet.

To do this, follow the steps below.

  1. Select the worksheet that contains structures.

  2. Click the Filter Structure button.

    images/download/attachments/1806958/Structure_Filter_Button.png
  3. On the Filter dialog, specify the query structure.

    images/download/attachments/1806958/Structure_Filter_Dialog.png
  4. Specify the Basic Search Options and the Chemistry Search Options.

  5. Specify the hit coloring and hit alignment modes.

  6. Select the structure column to filter on if there are more structure columns on the worksheet.

  7. Select the Filter Action > Action > Clone Rows option.

    images/download/attachments/1806958/Structure_Filter_Clone_Rows.png
  8. Select a destination worksheet for the results.

  9. Click OK to run the search process.