Forum Discussion
Tirtha Rasaili
Jul 19, 2018Copper Contributor
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
Sort By
- Tirtha RasailiCopper 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