I have so many text file in one folder. Now I want to check if the text file name is "a" or "b" or "c", then it will copy and paste to correspondence excel sheets ( Like text file a paste in sheet name a....). all excel sheets are empty. i want to just copy text file and paste in the correspondence excel sheet..
Can anyone suggest a code?
Thanks in advance