Copy specific data from one workbook to another workbook in power automate using office scripts

Hi All,

Can anyone help me in "Copy specific data from one workbook to another workbook in power automate using office scripts". When I tried to record in same workbook it able to record and generating the scripts but I tried to do the same to copy from one excel to another excel, it not generating the scripts. Can anyone help here ASAP as i have critical deliverable to do.

Regards,