The code I gave you will do what I said earlier:
"This can definitely be done in a macro if you are willing to start the
macro and then find the destination file in an open prompt...the macro
would then open that file...put in the 50 rows (how many
columns?)...and then close and save the file."

IF you need to have the macro open the files (and not you) that gets
much more complicated.