Hi,

i am trying to create a macro, which will run through a folder of different csv files and search for values of 100000 and then copy the entire row into a new workbook, which ideally will get updated every day.

is this possible? as the files have different names which is one area i struggle with and i struggle with copying the data into a standard workbook (which can be in another folder if need be)

thanks Dirk