Forum Discussion

Tirtha Rasaili's avatar
Tirtha Rasaili
Copper Contributor
Jul 19, 2018

How to copy entire row in a range of data (sheet 1) to Sheet 2 based on the multiple criterias

Hi

I am working on a list of new students who applied for finding a friends among students who are currently studying in my college. 
It is a friendship match. 

When the new students are matched with the old students, I want these to be copied to new sheet automatically.

 

Basically, In sheet 1 I have a lista of both new and old students. In Sheet 2, I want to write a text that matches with the certain cell value in Sheet 1. If that matches, I want the excel to copy the entire row from sheet one to sheet to.

I have attached en excel sheet with explanation on what I want to achieve.

I hope it is doable and someone will be able to help me.

1 Reply

  • Tirtha Rasaili's avatar
    Tirtha Rasaili
    Copper Contributor

    HI again, all in the Community. I would be so grateful for your answers. I can see that 23 people have seen. Do I have to explain my questions? Or is it not doable?

     

    Regards

     

    Tirtha

Resources