A few months ago we were trying to follow best practices and associate some activities of contacts with opportunities. Each opportunity is associated with an account.
We had an error when we were doing our vlookup in excel that caused a lot of our contacts' activities to be associated with the wrong opportunity. To be clear the activity is still with the right contact but now is also associated with an opportunity linked to another account.
I haven't figured out the best way to clean this up. My first thought was to delete the opportunities and start over re-uploading those. I quickly learned this would not work because it deleted all the associated contact activities.
Any suggestions would be much appreciated. Thanks!