Forum Discussion

Theraos's avatar
Theraos
Copper Contributor
Aug 17, 2022

Macro to separate data into different workbooks

Hi!, i would be really thankful if anyone could help me with this. I have a file wich has a number so big of entries that can only be accesed trough the transform data  (from csv) option, the thing is i need a macro to filter said file into different files based on a certain column, but because of it's size at the moment of opening it, a vast quantity of the information is lost, rendering any macro that i've found useles. Could there be some workaround for this? maybe use a macro in a blank file?. Thanks in advance!

 

PS: excuse me for any mispelling of orthography error, english is not my native language.

excel
Macros and VBA

1 Reply

  • Jagodragon's avatar
    Jagodragon
    Iron Contributor
    Aug 17, 2022
    If your csv file is too large for excel, you may have to use a script outside of excel to break it down.

    I'm thinking a power shell or CMD script using a CMD or bat format.

    I'm sure there are examples of this on those forums.