Our Company recently migrated from google to MS. I am new to MS power automate. I am looking for solution to create a script / flow to copy from range or table and paste it on last row of another sheet . I manage to convert google script to VBA but I am having issue with excel online script . Any help will be appreciated.
Source Sheet - Shift Logs-PM6 Target Sheet - Mill Issues
Working google script:
Current VBA code working on desktop excel:
With Sheets("Mill Issues").Range("A" & Rows.Count).End(xlUp).Offset(1)
Hi @VJR ,
I tried recording script. I can't figure out correct syntax for getting last row.
Below script recorded .
I found this but still don't know how you paste rage A1:L19 from sheet 2 to +1 of the rest row in sheet 1
Also found this.
This is what I have but it is wrong don't know how to make it work.
The solution to my issue is provided in the link below thanks, I understand how to do it now.
I hope it helps someone else.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.