Hello,
I'm working on a project where data is entered through a Sharepoint list. However, due to the requirements, I needed to create 56
eeek seperate Sharepoint lists. In the end, I need to be able to append all the data from the 56 seperate sheets that I've exported out into Excel, into one final master worksheet.
First, how would I even start to combine the data from the separate worksheets to build the Master worksheet with all data? Is it easier to export out each worksheet into a seperate book, or can I put all 56 worksheets into one workbook and then build the Master in it?
Second, how would I manage data that has been edited in SharePoint (i.e., a value was updated) and then also append new data that is not currently in the Master worksheet?
Any assistance is greatly appreciated! Thank you in advance!
I'm working on a project where data is entered through a Sharepoint list. However, due to the requirements, I needed to create 56
eeek seperate Sharepoint lists. In the end, I need to be able to append all the data from the 56 seperate sheets that I've exported out into Excel, into one final master worksheet.First, how would I even start to combine the data from the separate worksheets to build the Master worksheet with all data? Is it easier to export out each worksheet into a seperate book, or can I put all 56 worksheets into one workbook and then build the Master in it?
Second, how would I manage data that has been edited in SharePoint (i.e., a value was updated) and then also append new data that is not currently in the Master worksheet?
Any assistance is greatly appreciated! Thank you in advance!
