You’re offline. This is a read only version of the page.
Announcements
4
Hello all,
I wanted to see if anyone could assist in a follow that triggers when a new file in my document library shows up it will go inside the file and get the excel workbook. From there it will take a table row from inside the workbook and put it into a table in another excel workbook.
Basically I want to create a "database" of Table 1 (which is just a data collection table built into a excel template.) and have it put each table entry into another excel so all my data from multiple workbooks lives in one spot.
You may have solved this already, but I would start with this video. When a file is created, dynamically get the file name and first table. Then you can do "List rows in a table" and for each row, "Add a row" into your other static table/file https://www.youtube.com/watch?v=uaHxI2R1t4g
Share
Report
All responses (
Answers (
