Split data in different Excel tabs

[ArijitRoy]

Hi Team,

I have multiple files where I have lots of data that don't fit in one Excel sheet.

Can you help me to combine all the data into one Excel file? In one sheet the data should not be more than 1M. So if there are 5 Million data in total then I want it in one Excel file and it should create 5 sheets into one Excel file automatically.

I have attached 3 sample files. I only share 3 sample file and I have 10 excel files that I want to combine into one excel file and each sheet in it should have 1 Million rows of data.

Kindly help.

[TurboToad]

Here's one way you could accomplish this. Combining all the input, use record ID and formula to create the sheet groups. Could also use a directory input + dynamic input to simplify the input process. 

[ArijitRoy]

Hi, Only first sheet is strict to 1M but rest is moving to sheet 2 which holds more than 1M. Every sheet should contain 1M data not more than data. Tool is great but need small change in it. 

[binuacs]

@ArijitRoy a batch macro approach

[ArijitRoy]

Hi @binuacs ,

You are the best. The tool is working. Thanks for your help.