Thank you in advance for any help! I currently use multiple spreadsheets (Excel 2016, Windows 10) to track case information throughout a testing process. These spreadsheets are aggregated in a SharePoint that has a line item for each unique record. What I would like to do is update a specific (and static) field in the SharePoint that shows if the case fails or not. The SharePoint link would also be static. The goal would be to have the VBA reference the case number stored in the spreadsheet, refer to the cell that shows the final result then go into SharePoint and find the case number (a field in the SP) then override the final result field. This would remove the manual updates I currently go through every time a case is finalized or the result changes in the spreadsheet.

Is this something that I would be able to do using VBA? Overall, I would assume the finished state would be a macro in the excel file which you could run as needed in a similar way to a spreadsheet that pushes GL entries from Excel to the accounting system of record.