Announcements
Hi, Is there a way to Copy Excel Data with formula and paste only values in to another Excel Work Book. ( Power Automate Desktop)
Launch 1st Excel
"Read from Excel" -> This will result into a datatable called ExcelData.
Launch 2nd Excel (with a different instance)
Then use "Write to Excel worksheet" to write this datatable into the new workbook. In the Excel instance parameter give the instance of the 2nd workbook.
@VJRI don't have to write all of the data. It is only need to copy the data from the first work book's Colum C Row 2 to the second work book's Colum C Row 2.
For that purpose too you need to use the same actions. Use "value of a single cell" while reading and write to a single cell.
Thank you very much. It worked !!!!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 233
David_MA 217 Super User 2026 Season 1
Valantis 190
