Clone Results to a New Sheet

Back to index page

It is also possible to keep all structures on the original worksheet and to save the results of structure filtering on a new worksheet.

 

  1. Select a worksheet which contains structures (Sheet1).

 

Cells.FilterCopyNew1

 

  1. Open the Filter form.
  2. Specify a query structure.
  3. Specify general and chemistry search options.
  4. Specify hit coloring and hit alignment mode.
  5. Select structure column to filter on, if there are more structure columns on the worksheet.
  6. Select the Filter Action|Action|Clone Rows option.

 

form.FilterClonwRows

 

  1. Select a destination worksheet for the results.

 

form.FilterCloneRows2

 

  1. Click OK to run the search process.
  2. The results of structure filtering are displayed on Sheet 1(2) (specified destination worksheet) and all original structures are available on Sheet1. All original formatting options, headers and functions' specifications will be remembered and displayed on the new worksheet:

 

Sheet 1(2) (destination worksheet)

Cells.FilterCloneNew

 

Sheet1-original worksheet

Cells.FilterCopyNew1


Back to index page