web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Copy specific Data fro...
Power Automate
Answered

Copy specific Data from one workbook and paste in a template using VBA to save template as a new workbook

(0) ShareShare
ReportReport
Posted on by

Hi,

 

I have a fixed template for a delivery challan which needs data picked up from an excel generated invoice. Seeking assistance to create a macro/flow that would copy data from the invoice to specific cells into the delivery challan and save as a new workbook. Do help 

Categories:
I have the same question (0)
  • Verified answer
    v-yamao-msft Profile Picture
    on at

    Hi @ksheth ,

     

    Could you share more details on your scenario?

     

    Do you want to copy data from one Excel table to another and save it as a new workbook?

     

    If you would like to copy all the rows, please check the following flow for a reference.

    1.PNG

     

    If you would like to copy specific selected row, please check the following blog for more details:

    https://flow.microsoft.com/en-us/blog/introducing-microsoft-flow-integration-in-excel/

     

    Best regards,

    Mabel

     

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.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard