Learn MS Excel – Video 369- VBA – Export text file data in different text files



What if you have a text file and there are so many fields inside it and you would want to export every column data to different text file. Watch out for this amazing VBA Code which does the job so easily for you

-~-~~-~~~-~~-~-
Please watch: “Learn Excel – Video 594 – VBA – WEB SCRAPING – CLICK ON SEARCH BUTTON”

-~-~~-~~~-~~-~-

1 thought on “Learn MS Excel – Video 369- VBA – Export text file data in different text files

  1. Hi, in sheet 1 I have data need to transpose and paste it in sheet2. Example : in A columns has in sheet 1
    A B
    1 a
    1 b
    1 j
    2d
    2 l
    2 t

    I need output in sheet2 like below.
    A B
    1 2
    a d
    b l
    J t

    Please guide me how to do it using VBA or any shortcut method for six thousand s rows data

Leave a Reply

Your email address will not be published. Required fields are marked *