I have created a main sheet (Sheet A) with all the customer information and create Sheet B and use link & load to get field C,D & F. I’m able to pull the information from Sheet A to Sheet B but I’m trying to figure out how to update Sheet B from Sheet A every time one of our agent makes a change to the particular fields that are being recorded in Sheet B. How can I accomplish this task without need to go to every sheet and update each record but instead do it from Sheet A everything there is a change. I’m unable to used “Update value on another sheets” because I have multiple sheets pulling information from Sheet A .
If you want to sync your loaded fields when updating your loaded source field on the linked source sheet, please make sure to select Keep loaded value sync with source for the link and load relationship. Please refer to this document for more details.
Thank you, its exactly what I wanted to accomplish.