creating a master sheet from different .csv sheets

Hi All,

I want to create a master sheet with the data from multiple .csv sheets in one folder. The name of the sheet is in numerical value i.e., 1.12.03.csv (for the file of 1st December 2003, which is in .csv format). First row in each sheet will be the titles and second row is with data. The goal is to copy the data from different .csv sheets (with different dates ) and paste in one master sheet.

Waiting for your valuable suggestions in this regard.

With regards,
Upananda

pani_hcu,

Are the .csv files all in the same folder? Are the .csv files all in the same format, e.g. if column A is "Name", then all of the .csv files have column A as "Name"?

Should the data be copied one below the other or in separate sheets of the master sheet?

Is the master sheet also a csv file or a normal excel file?

Hi All,

I am sorry for not posing the questions clear. All the files are in same folder. and All the .csv files have the same first row with title and the data starts from the second row and Column A (A2). The title row may not be duplicated in the master sheet from each of the .csv files as it contained the same name across the .csv files. The data has to be copied one below the other in the same sheet. The master sheet is a normal excel file.

Hope i am clear in the above points

Thanks and regards,
Upananda