Create different sheet

[AnGi]

Hi team

I have this situation

gen-01

gen-02

gen-03

feb-06

feb-09

feb-11

feb-28

mar-04

mar-06

apr-03

apr-24

apr-30

mag-01

mag-06

Alex

Alex

Bob

Robert

Tom

Phil

Simon

Phil

Andy

Bob

Sam

Carl

Simon

Simon

Bob

Diane

Frank

Robert

Robert

Bob

Ryan

Simon

Phil

Max

Paul

Colin

Andy

Tom

Sam

Tom

Tim

Alex

Alex

Carl

I would like to create one excel file with different sheets based on column header

For example

gen --> sheet name; January

feb --> sheet name: February

and so on

Could you help?

[Qiu]

@AnGi 
I think we can do it by a batch macro.

[messi007]

@AnGi,

Please see below

I created the first formula to change the date gen => January, Feb to February I'll let you continue with the other months.

Below the result

Attached the workflow,

Hope this helps!

Regards,

[atcodedog05 · Accepted solution]

Hi @AnGi 

As @Qiu said batch macro is the way to go.

Workflow: I am getting the distinct sheet name and maintaining order.

Macro: In macro i using dynamic select tool keep only columns with month name in it. And also to change sheet name.

Output:

I have attached the packaged workbook if you are not able to open it because of version issue. Download/keep workflow and macro in the same folder should work. Output file is generated in the same folder.

Here is a blog on downgrading : How to downgrade packaged workflow (File types: .yxzp) 

Hope this helps 🙂