Excel auto Copy & Paste from Notepad and save it

[Wolfkrug]

I have over 5000 things to copy & paste to excel from notpad, But it is really hard when I have to save it for every copy & paste that I done, Is there a way to macro it or auto do it?

 

[Chihiro]

Yes. But hard to give you code/example without sample file.

Upload both the source text (couple of them) file and expected output (2 complete data line or more).

 

[pecoflyer]

Perhaps have a look at http://www.rondebruin.nl/win/section3.htm under "Copy every TXT or CSV file that you select in a new worksheet"

 

[GraH - Guido]

Dear Wolfkrug, why don't you simply import the notepad file (to avoid VBA code)?

Via the legacy Excel function:


Or if possible via Get and Transform (Power Query)


But like Chihiro says, difficult to help you out without some sample data.

kr
G.