Office script
Transfer data one sheet to another URL sheet using office script
Forum Discussion
- Can you please provide more detail?
- 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) (exceloffthegrid.com)
If you mean another workbook that doesn't work. Office Script works only with objects within active workbook.
