Does anyone know where I can find a sample Excel VBA macro that will read one or more excel files from a specific folder location, retrieve data from certain cells of each excel file, and write the data one row at a time to a new excel file?
Many thanks
MM