I have a spreadsheet in a SharePoint Online library. The library has several columns of metadata, say A, B, C and D. The first two are text and next two are numbers.
I would like to do two things:
- I have two named cells in my spreadsheet, Field1 and Field2, which are inputs in my spreadsheet model. I would like these fields to be automatically populated when I create a copy of the spreadsheet in the library. Ideally, if A or B change in SharePoint, I need Field1 and Field2 to be automatically updated.
- Two more named cells in the spreadsheet, Field3 and Field4 are outputs of my model and I would like the SharePoint metadata C and D to be populated/ updated based on the values in these fields in my spreadsheet.
I am open to having VBA codes in my spreadsheet to achieve one or both of the tasks. Many thanks