Morning guys,
I need some help with some code to combine the data that I have in 40 files, all within one folder into one Excel worksheet.
I need from rows 8 to 508 in each file but it could just be row 8+ as there should be no blank rows.
There are two sheets in each file but I only need the first sheet, this is named "MasterData (2)".
I have tried a few codes but there seems to be no output.
Thanks.
I need some help with some code to combine the data that I have in 40 files, all within one folder into one Excel worksheet.
I need from rows 8 to 508 in each file but it could just be row 8+ as there should be no blank rows.
There are two sheets in each file but I only need the first sheet, this is named "MasterData (2)".
I have tried a few codes but there seems to be no output.
Thanks.