Greetings, all!
As the title would imply, I am looking to routinely merge 5 (satellite) workbooks with one worksheet each into a single (master) also with one worksheet. The satellite files will have varying amounts of data. Basically, the code would need to select all rows with a value in column "A" (from column "A" to column "S") in the satellite files, then cut and paste the values into the first empty row of the master file.
There doesn't need to be any sorting and the worksheets are free of any formatting. The VBA would ideally be a standalone workbook whose only purpose would be to perform the merging. In the thread title I mention "routinely", and I was just planning on using Task Scheduler to open/close the standalone workbook every night (with workbook.open being the event that runs the code). I was trying to avoid a wall of text but if exactly what it's for would help let me know.
Any help would be greatly appreciated.
Thank you!
Bookmarks