I am a membership manager in an international organization and I was hoping to get some help optimizing our members' contact list.
There are three kinds of members, NCs, LCs, and IMs. I have a Google Form that allows members to fill out their information dependent on whether they are in an NC, LC, or IM. This pulls their information (country, city, phone, email, etc) into a Google Sheet. In another sheet of the same file, I have it partitioned off; listing the NCs on one sheet, the LCs on, and the IMs on another.
One of the first questions they answer on the form is to select NC, LC, or IM. I want to create the other sheets so that they scan the form data and if it says "NC", then pull that row into the NC form and the same for LC and IM. However, I am not sure how to write a function that will essentially skip the other two membership types and properly fill the three sheets with the cataloged data correctly.
For example: Form Sheet (updated when someone fills out the contact form)
This would sort the first row into the NC sheet, pulling in all the information. The second would go to the LC sheet, and then the IM sheet for the third row. But if the next line was an NC, I also want the NC sheet to be able to grab the first row, skip the next two rows, and then pull the fourth row into the second row of the NC sheet. If that makes sense.