Forum Discussion
Desmania_Design2365
Mar 11, 2024Copper Contributor
Office script
Transfer data one sheet to another URL sheet using office script
4 Replies
Sort By
If you mean another workbook that doesn't work. Office Script works only with objects within active workbook.
- JKPieterseSilver ContributorCan you please provide more detail?
- Desmania_Design2365Copper Contributorusing office script, as soon as the data appears in the sheet of one workbook , it gets copied to the other workbook , i want this.
That's with Power Automate, Office Script itself works only within the same workbook.
How to develop flow in Power Automate depends on how your data is structured. Is that structured table or range where new data appeared, do we speal about adding new data or updating old one or both, etc.
Some sample in this direction
Move data between workbooks (Power Automate+Office Scripts) (exceloffthegrid.com)