Kindly help me with excel macro.I am new user to macro.
I have 1000 files in CSV format with two rows in each.These files have name which contains information which is specific to the particular file.So now I have to merge all these file in new worksheet and also there file name in new column.
please help me out with these
Bookmarks