create new worksheets using unique values

[bhavsarsangam106]

I have an Excel workbook named Sheet1 having master data. In which S column is having 4 unique values as 5121 , 5122, 5123, 5124 and would like to create separate worksheets by that name as per the unique values in column S. Additionally, I want to copy and paste entire row that correspond to the each unique value into their respective sheets. please give me the solution.

[binuacs · Accepted solution]

@bhavsarsangam106 one way of doing this

[Raj]

@bhavsarsangam106 
using output tool capabilities this can be achieved
you can refer the attached example with the tools as well.

[bhavsarsangam106]

thank you for your time however i could not find any output.

can you please guide me more on this.

appriciate your assistance.

[bhavsarsangam106]

hey raj

thanks for your time.

i think you forgot to attach the file or flow.

can you please re attach or guide me through

[binuacs]

@bhavsarsangam106 the output files will be created where your workflow saved by default

[Raj · Accepted solution]

@bhavsarsangam106 
please find the screen shot attached for reference.

Hope this helps.

[Raj · Accepted solution]

@bhavsarsangam106 
is this solved?

[bhavsarsangam106]

Hey Raj
Thank you so much for solving this.