Formula Help

Hi,

No formula can achieve this task:

- Find a sheet a specific cell entry (ex. "U").

- Copy the row that contains that entry into another worksheet.

What you need is an application written in VBA to accomplish this task!

Anyway, you can simply use some formulas to find a specific entry in a single cell, or a range of cells, then copy the results to another worksheet manually, as shown below:

Ex. "u"

Here you have to press (Ctrl Shift Enter), to force the formula to deliver the right result.

You can filter the rows that contain true values, and copy it to another worksheet manually.

NOTE: The match type in the above solution is case-insensitive, if you want it to be case-sensitive, then replace the word of (SEARCH) with (FIND) in the formula.