I have a process where I want to merge multiple excel files into one file. All the files have the same data but saved by city name in one folder. Do I use the Copy Paste Range and/or the Append Range? I want to use a For each in Folder to get each file. Can anyone help
If you want to merge them into a single sheet, then you’d want “Append Range”. “Copy and Paste Range” will overwrite the data where append will automatically place it at the end.