hi All,
I would like to append 4 excel files at the same folder (append all content of sheet named "append_sheet").
is there any way to have a new column that shows filename in the output file?
example: consolidate 4 files excel , each file have sheet "append_sheet", in the output file iwould like to have a column which can show the source file.
If can dynamic by input source file in a cell on sheet , that would be great.
I would like to append 4 excel files at the same folder (append all content of sheet named "append_sheet").
is there any way to have a new column that shows filename in the output file?
example: consolidate 4 files excel , each file have sheet "append_sheet", in the output file iwould like to have a column which can show the source file.
If can dynamic by input source file in a cell on sheet , that would be great.