Power Automate Desktop - Copy cells from a worksheet to another

Learn how to copy a range of cells in Excel from one worksheet to another!
Follow me for more goodness:
Twitter: @veronicageek
Blog: veronicageek.com
Github: github.com/veronicageek

[@user-vn4cd5xe6q]

Good video. Can you show how to clear the excel table before pasting copied values

[@veronicageek]

You have an action in PAD to clear cells for a range or an active cell: learn.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/excel#clearcellsfromexcel

[@yusun4755]

can you show this one in power automate online version, not the desktop version.

[@marcin8509]

You are awesome! Thanks!

[@joellopez889]

Is there a way to copy excel range to outlook message keeping the excel cell format?

[@jayshah9462]

Hi, Thank you so much for the video. you're the only one who's addressing this issue. but can you make the video for online version where we can pull the data form sharepoint file and paste into the sharepoint file. or can you create the new video where we can close 1st excel file with copy cells on clipboard and then paste into new file. because my data is getting deleted when I close 1st file to paste the data into 2nd file. I also try without closing the 1st file but then system is pasting the data into same file.

[@veronicageek]

Thanks for the comment Jay, I’ll test and post a video if I can get it work!

[@chandanchakrabarti2254]

Hi , Thanks for the video. I have one query - If my excel has several tables and worksheet, how can I connect to specific worksheet ( EXCEL is in share point)

[@veronicageek]

You can use the "Set active Excel worksheet" action first, and then get the data you need from that worksheet

[@ajayrathod7777]

Can i copy cells and paste into ppt?

[@anush7386]

Don't it work if there is a blank space

[@abhishek030884]

Thank you for the video. Can you also help with an example where we are copying cells with formulas and pasting it as values ?

[@veronicageek]

Will add it to my list for sure!

[@veronicageek]

Video dropping this week!