Hello Riz,

Thanks for the updated workbook.

If I understands this, the file name is in A15 and if the check box is checked then the macro will search the folder path using cells in columns "K1:L6"

What information is to be copied into the cells in columns "M1:N6"?