Multiple CSV Import

[welshobitt]

Hello,

Can anyone help me? :help

I have to backdate very quickly a report with roughly a years worth of CSV files produced daily.

I 'm basically looking for a quick way that these files can be imported into one spreadsheet, but opens them in turn and in order so that a date can be entered to show the date the file was produced in one of the spare available columns.

Can this be done:think:

[Zack Barresse]

Hello, and welcome to the board!

Yes, this can be done. We would need to know what version(s) of Excel you are working in, a basic explanation of your data structure, where you will house your code, what workbook you'd like to import into (new vs existing) along with which sheet (new vs existing), where your files are located, if there are any subfolders and if you'd like to check them as well, where you want your data to overflow to if we hit the sheets row limit, and where you would like your date inserted.