Share
Report
50Hello,
I have a process wherein all my Excel files reside on SharePoint. Hence I will refer to them as SP1 and SP2 files.
I have to copy the data from SP1 to SP2. Then on SP2, the data will be compared with its other worksheet data and the matching entries are copied to a 3rd worksheet within SP2.
SP1 is the Input file where I will get new data every month on some particular columns.
SP2 has multiple worksheets, referred here by SP2.A, SP2.B, SP2.C
SP2.A is the destination where the data will be pasted from SP1. Please note that a new column has to be appended every time to previous data.
SP2.B has the data to which SP.A needs to be compared.
Next, with some Excel formulas, the matching entries are copied to SP.C
'Add a row into a table' & 'Update a row' actions from SharePoint work only when there are no dynamic rows, as they require Key row.
Are there any other actions that can be used to automate the above process?
Or do I need to download them all to my local drive and after all the manipulation(like in regular Excel), update the file back to SharePoint?
Thanks.
All responses (
Answers (
