I have a speadsheet that with the following fields:

Partner Sector Product/s Current Provider Target Partner
A C E G
B D F H

Under the target partner will either be a yes or no. I have written a macro
that will copy the data to a second spreadsheet if this last column is yes.
Once the data is in the second spreadsheet there are extra fields to be
filled in next to the ones copied over.

My problem arises when, say, I say yes to partner B then copy over the data
and add data to the extra fields. At some later stage I chose to target
partner A. My macro would then copy partner A's data in the place of partner
B's and partner B's data in the line below.

I have over a hundred partners so would need it to cope with a number of
changes to targeted partners.

If anyone has any suggestion they would be most appreciated.

Many thanks.