To use a loop or a subflow depends a bit on how/why your files change and how you want a finished file to look.
Is the file in your original post something that is generated from a template, and there are many files that are similar?
If so, you could first use the Get files in folder-action and use the file filter with *.xlsx to only get excel-files. (This can be somewhat slow if your folder contains very many excel files)
Then you use a For Each Loop where you:
- Open the Excel instance,
- Do the copy/paste-actions,
- Save and exit
and then it will repeat these actions until you've gone through all the files.
Here's what this looks like
This may not be your scenario, but with loops you can do pretty much anything that needs to be repeated. Be that within a single file, or with multiple files as loops can be nested
If you want more help, feel free to DM me and I can try to help you on my spare time
Best of luck!
