Dear All,
Each client send their excel input files with different sheet names, how to combine all the client input files into one? (lets assume the columns are in the standard format) Please advise if you have any solution to combine if the format is not standard and the starting row is different.
Thanks in advance.
Karthick
Solved! Go to Solution.
You can also build a macro to read the differents sheets and the advantage is you can customize the things that you need.
I attached an example
Thanks for sharing 🙂