[FAQ000022]Can the results of a search done on Sheet 1 be displayed on Sheet 2?

Q

CELF seems to be able to switch between sheets, but can the results of a search done on Sheet 1 be displayed on Sheet 2?

A

Like in Excel, you can refer to the values of cells in other sheets in the following format.

<Sheet name>!<Cell adress> （e.g. sheet1!B2 )

The following link provides a detailed explanation on how to create a separate sheet for searching from the sheet to be displayed.

Keep the retrieved data in a hidden sheet and refer to it from another sheet