Consolidate Data from 5 excel files to one

I have 5 files of excel files. I want to merge in one file. I tried to get range and set range but it doesn’t work. How to append to the end of the column?

Hi @rodel.sarate

You can vote to add it as a feature in this topic

You can use this solution int he meantime:

Here is a sample recording (24.5 KB)

perfect. I did the right one. This is exactly what I did.


Thank you so much.

1 Like