Get data from multiple Excel files and add it to existing Excel file

General
1

Hi

I'm new to node-red and I'm not sure if my problem can be solved. But I'll try anyway :slight_smile:

I have multiple Excel files running on my OneDrive that I'm sharing whit my coworkers. The files are identical and I need to summaries the amount of items used in row "E" from the shared files in to a separate Excel file. This file will just be used to have a overview of the amount of items used in row "E" from the other files. The shared files will only send the data to the overview file when the user saves the file. And every time the make a change the overview file get a new number to add to the exciting number in row "E".

I hope it makes sense of what I'm trying to achieve.

FIlename COW1
FIlename COW11546Ă—671 21.5 KB

FIlename Sum
FIlename Sum1540Ă—667 20.7 KB

2

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.