Hi, I would like to be able to collect the data in a particular cell across many .csv files (located in the same folder) and place that data in a single summary excel file (possibly in a single column). If possible, I would also like to pull the name of each file and place it in cell adjacent to its cell data, in the summary file. Any help would be much appreciated.
Thanks
Bookmarks