Dynamic filter and have them pasted in different excel files

Hi All,

I need the help in the following problem. I have a dynamic requirement of filtering the value in one excel and copy to another excel as output.

Filter records should file value from Input and split them into File 1 & File 2

	Input		File 1		File 2
Filter	Filter_col	source	Filter_col	source	Filter_col	source
a	a	1	a	1	c	2
b	c	2
c	d	3
d

Thanks

Naga

Batch Macro

Iterative Macro

Accepted answers

binu_acs

@Naga The output tool has the ability to save the files in different names based on a column value. Attaching the sample workflow for your reference. In the given example the workflow saves three files with the name of the filters a, c, d and only contains those records

Filter_090223.yxmd

All comments

Anybody can help

@binu_acs - Much appreciated. Thanks for this solution and it helped.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703