Office script

[Desmania_Design2365]

Transfer data one sheet to another URL sheet using office script 

[#2]

Can you please provide more detail?

[#3]

@Desmania_Design2365 

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

[#4]

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.

[#5]

@Desmania_Design2365 

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)

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