I need to merge two excel files. each file has same column names but their orders are not samefile1.xlsx (14.5 KB)
simply read range for each file and then append to merged file (or merge datatable) is not working as expected.
Can anyone advise?
I am still learning.