Name Time/Date log of merged files data

[tvsramesha]

Hi All -

We are using file merge function to merge the contents of excel files, each excel file is unique with name, date and time.

When the files are merged the contents of the file get merged row wise - at that time, we want to include the file name of the merged files as one of the logged data and bring to last cell.

Thanks in advance, if I, can be guided on the above.

Best,

Ramesha