Automated Excel Data Extraction - Specific rows and columns only

(0) Share

Report

Posted on by paulkim4dplex

Hello.

I'm hoping someone could help me with my issue.

I receive multiple excel files from 6 different clients with sales figures from the previous day (dates, amounts, location of sale, sales percentages, etc.). Each client has their own format and some have additional data that I don't need.

I'd like to see if Power Automate could help me pull just the data I need from each of my client's daily Excel files and pull just the cells I need into a new Excel file so all same data is organized in it's own column.

I'm thinking the following steps.

1. Open selected excel file

2. Copy specific rows/columns of data (ex: rows 3-60 & columns A-D, H, P-S)

3. Paste the copied rows/columns into a different Excel file (but in a way where the columns are not separated as they were in the original file)

Thank you very much in advance.

Paul

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @paulkim4dplex

I think u need to pull specific data from all the client files & then combine in single excel file?

Correct me if i am wrong

Thanks & Regards,
Nived N

Was this reply helpful? Yes No
paulkim4dplex 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Nived,

Thank you for the response.
Yes, that's exactly what I'm looking to do, but automated.

Thanks,
Paul

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (1)

Report
Copy link

Link copied!

As long as the 6 sales agents are giving you the same columns every time, I would recommend Excel VBA. So, PAD’s responsibility is to get all 6 files into tabs on a worksheet, and then VBA would gather (or combine) data from those 6 tabs with a standard process. VBA is always faster than PAD when it comes to Excel tasks.

Was this reply helpful? Yes No