I need to copy the content of 24 excel files to an other 24 excel files.
So the idea is to use read range and write range. But the issue is i will have to make like 12 read activities and 12 writes activities.
So, i figured! i would use an array for each of the files.
So the idea, is that i get all the 12 files names and all the 12 names of the other files. both saved on diffrent variables as arrays. Than i use for each to iterate on the 12 first files to read each one of them, and iterate on the same time on the 12 others, so they can save the content of each one them simultaneously.
One other issue, is that i have to copy the data from a specif file to an other specific file, which i know both names for all the 24 excel files.
This is an example, trying to fix it.
TEST.xaml (8.5 KB)
Any ideas on how to proceed please?
I excuse for my bad english