This assumes both files 1 and 2 are open, with sheettabs in each file the same name as the file File1 and File2.
Looking for some VBA that would copy source file (File1) to target file (File2)
File1 has headers so all I want is rows under the headers (row1), even if there is only one row of data. There will always be at least one.
Append to File2, even if all that is in File2 is the headers (row1). If there is data in File2, append to the bottom. if there is data in File2 already there will always be data in columnA.
I do not have sample workbook, but I believe this is pretty straight forward. I seem to have issues when there is only one row to copy and when I do an xlDown it grabs all.