0

I have a requirement to perform a bulk update on Contacts using Excel Online, but there is a set of entities with a N:N relationship to Contacts that need to be filled in order to facilitate data input.

As it's impossible to edit this kind of relation for each contact record in Excel Online, I would like to receive recommendations to overcome that limitation.

felipe.zkn
  • 2,012
  • 7
  • 31
  • 63

1 Answers1

1

It’s going to be a manual exercise of having multiple files/sheets, with the help of vlookup or some macros - you have to manipulate (copy/paste?) the result to Excel online sheet.

Arun Vinoth-Precog Tech - MVP
  • 22,364
  • 14
  • 59
  • 168