Filter Excel with Excel

(1) Share

Report

Posted on by Bergh

88 Season of Giving Solutions 2025

Hi! I have two different excel sheets. The first contains 50000 rows (MasterT) and the second contains 100 rows (FilterT).
FilterT contains different project numbers and subproject numbers, these are used to be able to filter MasterT.
So what I want is to filter MasterT based on FilterT, be able to create new Excel sheets for each Project number and save these in a folder
I have tried now but it take long time and i get mail that i use to mush memory.

Lets flow together

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

You must share your flow, there is nothing here to validate since its just data you are sharing.

My guess is you are looping through all 50,000 versus filtering querying it, but I cannot tell.

Was this reply helpful? Yes No
Bergh 88 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

I have deleted the flow, and I have not started on a new yet.

Was this reply helpful? Yes No