What if I know precisely the name of the destination file,
as well as its location (Lookup?)?


-----Original Message-----
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.

.