Copy Results to a New Sheet
Back to index pageIt is also possible to keep all structures on the original worksheet and display the results of structure filtering on a new worksheet.
| 1. | Select a worksheet which contains structures (Sheet1). |
| 2. | Open the Filter form. |
| 3. | Specify a query structure. |
| 4. | Specify general and chemistry search options. |
| 5. | Specify hit coloring and hit alignment mode. |
| 6. | Select structure column to filter on, if there are more structure columns on the worksheet. |
| 7. | Select the Filter Action|Action|Copy Rows option. |
| 8. | Select a destination worksheet for the results. |
| 9. | Click OK to run the search process. |
| 10. | The results of the structure filtering are displayed on the Sheet2 (specified destination worksheet) and all original structures are kept on the Sheet1. |
Sheet2 (destination worksheet)
Sheet1
Back to index page
Do you have a question? Would you like to learn more? Please browse among the related topics on our support forum or search the website. If you want to suggest modifications or improvements to our documentation email our support directly!