Posts by Gretel

    Place this macro in a regular module in your destination workbook and run it from there. Make sure this workbook contains a sheet named "Master". Save the workbook as a macro-enabled file. Since your files are in different folders, you will be prompted to choose a folder and a file to open.

    Hi Mumps,

    I could really use your help. This macro does exactly what I need it to do, but I could use some help tweaking it so that it processes all files within the folder without me having to select each file and leaves out the first line as they are headers. Is this possible?

    I fully realise that I'm piggy backing off your hard work, but it's a gem of a macro and will save me a lot of time.

    Many thanks,