Hello,

I'm looking for a visual basic code which will combine multiple files in a folder called 'Freight' all of which have the same layout and design, but each of which contains different data under the headings and a different amount of data in each file.

The title in each file takes up the first 3 rows, the data typically goes from column A to AE and possibly from row 4 to 100.

After copying all the files into the master worksheet I would then like the worksheet to be sorted by invoice date, which in this case is in column X.

My idea is that by sorting the data it will sort all the blank entries to the bottom of the worksheet so there won't be any gaps in the data. The files may have different names so I would like the code to copy all the files in a specific file path instead of just naming the individual files. I would also like the title on the master file but because the title is the exact same in every file and takes up the same rows I only need it copied from any one file.

The current code I have combines all the files into one master workbook but it copies each individual file into a separate worksheet, which is obviously not what I am looking for.

Anyone up to the challenge?

I appreciate any help I can get

Johnny_Canuck