Change excel file in batch
Hi all,
I have a lot of identical files in the same folder, all born from the same template: the only difference between them is their file name and the values inserted manually in the unlocked cells of each sheet. I’m guessing if there is any way to change the formulas of each file by just changing the original one and get it all reflected at once (let’s say I find out I did a mistake in some cells and want to change for all the files).
I’m up to any solution, even using power automate or some crazy script.
Really hope someone can help,
Many thanks
Hi all, I have a lot of identical files in the same folder, all born from the same template: the only difference between them is their file name and the values inserted manually in the unlocked cells of each sheet. I’m guessing if there is any way to change the formulas of each file by just changing the original one and get it all reflected at once (let’s say I find out I did a mistake in some cells and want to change for all the files). I’m up to any solution, even using power automate or some crazy script. Really hope someone can help,Many thanks Read More