• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Import data from cells which is containing specific phrase or value

S

shazzad

New Member
Hi All,

I want to import data from one sheet to another sheet. The sheet is containing data under the date. The range i want to import is containing values named "APP-XX" and "KRL-XX". And there is a value just under specified value. I want to import the values in another sheet which has the phrase "APP" including the number(XX). but not "KRL-XX" Please have a look at the below screen shot.

11.JPG

In picture, I want to import all the cells except "KRL-XX" and the values just below of this.

Can you please let me know the formula or ways to import it on another sheet???

Thanks in advance.


Regards
Shazzad
 
Last edited by a moderator:
You must log in or register to reply here.
Back
Top