Required Tab wise data with calculation

Question

Hi Team,

I have input file " attached" where in two different data combined in one sheet in which "WBS Reference 2" is common. I want to separate the data in different tabs with heading " Required Tab wise " file attached in which i needed the data. Can you please help to prepare a workflow.

Regards,

Mahesh

Input.xlsx

Required Tab Wise.xlsx

Maheshp · Answer

Hi,

Thanks for the workflow, this will help to separate the data in different tabs. but in each excel TAB i want calculation also which i have mentioned in the excel file " how it should look like"

Regards,

Mahesh

binu_acs · Answer

@Maheshp one way of doing this

WS_Ref_19032026.yxzp

OTrieger · Answer

@Maheshp 
This is something that you should know how to do as you built WFs in the past. Filter the data and then write them out to the same file into 2 different tabs. You can define the tab name by adding 3 pipes after the file type, such as .xlsx|||tab1