copy and pasting in a sorted excel file

If I had an excel file that contains names of all wedding guests, and I sorted for those that RSVP a yes to the wedding I call this excel file EF1. Then, separately, I have another excel file (EF2) that shows all the meal options of guests that RSVPed a yes to to the wedding. Then for whatever reasons, I wanted to copy & paste the meal options from EF2 to the "sorted to yes" EF1. However, since EF1 is sorted when I paste the information from EF2 to EF1, some of the information pasted over to EF1 will be pasted to the cells that are not showing (guests that RSVPed a no). For example, if on EF1 guest from row 1 is a yes, from row 2 is a no, and row 3 is a yes, but I sorted my EF1 so that row 2 isn't showing when I am reading it. So, when I am pasting information from EF2 (which already eliminated all guests RVSPing a no. therefore, the same guest from row 3 in EF1 will take up row 2 in EF2) to the sorted EF1, the information will be pasted to row 2 instead of 3 in EF1. Is there a way to solve this? Thanks!