Needed help on copying the data from .csv file to another excel sheet
Hi All,
My requirement :
1) I have attached 2 sample sheets [ book1.csv & bokk2.xls ] .I want to copy the data from book1.csv to book2.xls with single click .while copying it should copy the whole data [ 4 columns ] to book2's first 4 colums .and should save it as the same file name [ as book1.xls ]
Like this i have plenty of .csv files to be converted into predefined .xls sheet .
So could you please help me to do this using a macro
with single click it should copy all the .csv files which are present in a folder to another predefined .xls sheet and should save the files as same name with .xls xtension
Hope you guys can help me on this ..
Thanks in advance .. this will realy helps me alot ...! reduces my work