Hello,
I need some direction or a best option.
I want to synchronize data between Excel and a SharePoint List (online). I am using Excel 2016. My Excel file is the master file and I need to update a SharePoint list with the excel file.
I am currently copying snd pasting, but that is not efficient. I need a way to synchronize excel with SharePoint.
My thoughts are to sync using Access or via Excel VBA. What would be the best option?
I am doing this at work so I am limited to what I have. I can’t use a third party source. All I have is the basics in Excel, Access, and SharePoint.
Thank you
I need some direction or a best option.
I want to synchronize data between Excel and a SharePoint List (online). I am using Excel 2016. My Excel file is the master file and I need to update a SharePoint list with the excel file.
I am currently copying snd pasting, but that is not efficient. I need a way to synchronize excel with SharePoint.
My thoughts are to sync using Access or via Excel VBA. What would be the best option?
I am doing this at work so I am limited to what I have. I can’t use a third party source. All I have is the basics in Excel, Access, and SharePoint.
Thank you