How to split a excel workbook into 4 sheets

Question

Hi All,

I wanted to split a excel workbook into 4 sheets (such as >90 Days Values, >90 Days Items, >360 Days Values and >360 Days Items). Then I have to  dynamically rename the workbook as monthwise (Eg: Workbook_August 2023) at a time.

Totally there are 5 columns are there. Out of I wanted to remove columns such as  File Name & Additonal column only.

Is there any way to do this? Please help me.

Test.yxmd

binu_acs · Answer

@Ganesshh_TL Like the below workflow?

Test (9).yxmd

Ganesshh_TL · Answer

I will be splitting the workbook into 4 sheets based on this column (Additional Column).

But I wanted to remove the column called  "Additional column" also.

Using the column  called  "File Name" I wanted to dynamically rename the workbook monthwise as "Workbook_August 2023"

binu_acs · Answer

@Ganesshh_TL One way of doing this

Test (9).yxmd