I am looking to add data from four excel files to a single empty file(Lets call it Results.xlsx). After copying the data from the first file to Results.xlsx, would it be possible to add the second file’s data to the bottom of the list on Results.xlsx? And so on with the next few files.
I was able to copy the data from the four files onto Results.xlsx but only onto a certain range.
Is there a simple way to remove empty rows between the sets of data in this file?