Office script

Copper Contributor

Transfer data one sheet to another URL sheet using office script 

4 Replies
Can you please provide more detail?


If you mean another workbook that doesn't work. Office Script works only with objects within active workbook.

using 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) (

Solved: copy excel rows from one excel file to another exc... - Power Platform Community (microsoft....