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.
@Ganesshh_TL One way of doing this
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"