Forum Discussion

Chera Coates's avatar
Chera Coates
Copper Contributor
Oct 19, 2017

Formula Help

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?

Formulas and Functions
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Oct 20, 2017

    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.

Resources