Move data between workbooks automatically with Office Scripts & Power Automate | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy


★ Check out the blog post★
https://exceloffthegrid.com/move-data-between-workbooks-power-automate/


★ About this video ★
Normally in Excel online, data cannot be passed from one workbook to another. In fact, Excel online doesn't even know that other workbooks exist! However, using Power Automate and Office Scripts, we can create flows that can transfer data between workbooks automatically. And... we can make it happen automatically without needing to open workbooks, or copy and paste #AMAZING!!!!

0:00 Introduction
0:25 Example
1:18 Get data from Excel
3:33 Paste data to Excel
5:02 PA flow to move data
8:03 Running the flow
9:08 Conclusion

★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/


★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com


Twitter: https://twitter.com/exceloffthegrid


#MsExcel

Скачать видео