Is there a way to copy formulas from one excel file to all other excel files ?

[szakharov7723]

So I have certain formulas (in range) in one excel file, and I need to copy-paste them into other excel files grouped in folders.
I wonder if it is possible to do it with VB coding or any other methods ?

Formula range is simple and looks something like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]=A6[/TD]
[TD]=I9[/TD]
[TD]=AZ3[/TD]
[TD]=O12[/TD]
[TD]=L1[/TD]
[/TR]
[TR]
[TD]=AA4[/TD]
[TD]=J2[/TD]
[TD]=Q1[/TD]
[TD]=U9[/TD]
[TD]=V17[/TD]
[/TR]
[TR]
[TD]=B7[/TD]
[TD]=AA1[/TD]
[TD]=P2[/TD]
[TD]=N14[/TD]
[TD]=AZ6[/TD]
[/TR]
[TR]
[TD]=Z1[/TD]
[TD]=C8[/TD]
[TD]=G12[/TD]
[TD]=P32[/TD]
[TD]=B12[/TD]
[/TR]
</tbody>[/TABLE]


other files have the same data structure, hence copy-paste range is the same. The only problem is high amount of files, so it would take lot's of time to do it manually.

 

[Rijnsent]

Hi Szakharov,
that sounds like something VBA could handle for you but might indeed take some time. To get you started:
-switch macro recording on and do it for one file manually
-use e.g. this code https://www.mrexcel.com/forum/excel...g-excel-files-external-links.html#post5346946 to get a list of all excel files (you might want to change the macro so it only lists specific files (maybe identified by some name or feature?)
-merge those two blocks into one bit of code that can update all files for you.

If you get stuck, please post your code here so people can help you further.

Cheers,

Koen