Spilt big file- Macro for pivot?

[Alka Bajaj]

Hi Expert,

Need your guidance urgently on below.

I have an excel file with 220,000 recrods, which needs to be splitted into 14 diferent files based on one of the column values.
I do have a macro to perform above functionality, which worked fine on 70,000 recrods. But it is not wrking on 220,000 records, getting hanged.

Can u suggest an alternative method? One method I can think of is creating pivot table and putting particular coloum values in a row data and them clicking 14 times on each value and creating 14 sheets and then renaming them. Is it possible to have a macro code for this?

Really need your expert advice,

Thanks
Regards
Alka Bajaj

 

[Alka Bajaj]

Hi Expert,

Please please your guidance required in this matter.

Many thanks/

Regards,
Alka Bajaj