Remove post

(0) Share

Report

Posted on by Alphadrag

164

Removed

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Alphadrag ,

Will VBScript will suitable for you, then try like this,

WB.Sheets("View1").UsedRange.Copy WB.Sheets("View1Pivot").Cells(1, 1).PasteSpecial Paste:=xlPasteValues

I'm
Balamurugan2022

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

I know im a Power Query fanboy but why the hell not 😀
Power query that range, output to new sheet whilst removing any empty rows.
When you want to then send this its just a matter of selecting all, copy n paste etc.

Was this reply helpful? Yes No
Alphadrag 164 on at

Like (0)

Report
Copy link

Link copied!

removed

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

There are multiple ways.

If want to use PAD actions then...

- Loop through the cells starting from B5 to lastfreerow minus 1. Use "Read from Excel worksheet (value of a single cell)"

- If cell value found empty delete entire row from Excel

- Then "Read Excel worksheet". This will get the results into a datatable without the blank rows

- You can do this by opening the file in read only so that the original file is not impacted - Launch Excel (Read only option)

- Close the excel without saving

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

Are you always writing to this Excel sheet as in appending or is it a new excel sheet every time ?
Which rows are you looking to paste into a second file ?
Lastly does this second file already have data as in more appending to ?

There are loads of different solutions like the others posted but depends on what end result you require.
If I can do it in Power Query without PAD all the better, less things to go wrong so to speak.

Raw data with an empty row.

Power query removing the empty row

Was this reply helpful? Yes No