automation

[Guest]

Hi there;
I am copying specific cells from a file (actuallu use the address approach,
like aa!c12) to another file. The cells address in source file are always the
same, but in target file changes each time to lower rows than previous one. I
have 100 source files at least, how to automate this, instead of clicking at
each cell each time between source and target files.
Thanks for your help.

 

[Guest]

in your target file,
use dir to get the first source file,
copy the cell(s) desired,
close this source file,
use dir() to get 2nd file
and repeat till finish