Copy data from one workbook to another of same name
I'm a bit desperate, so yes.... At around 100 files, and
the close and save being automated (?), shouldn't take too
long, yes?
Anyway, I'm all ears if you can point me in the direction
to start....
TIA!
-----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.
.
|