Formula Help

[Chera Coates]

Hello,

Please help!  I am attempting to do the following via a formula:

Look up on a sheet a specific cell entry (ex. "U") and if it is there, copy that row over into another worksheet. 

The issue I am having, is that I need to somehow skip copying over rows that don't meet that "U" criteria.  I don't want blank rows in the worksheet.  Is there a function I can use to say if the cell doesn't match that "U" then skip it and search the next row?

Any ideas?

[#2]

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.