Good Day,

I am putting out a request for some help?

I have a folder called PRMResults. It contains test records in .csv, a lot of them!! The test records are named after the serial number of the tested unit. Each record has 10 columns of data starting from the second row down, the first being the headings for each column.

I would like to copy only the contents of columns B, D, E and G from each work sheet in the folder and paste into a new workbook. Could someone provide a script that could do this.

Thanks