szakharov7723
Board Regular
- Joined
- Jun 22, 2018
- Messages
- 85
- Office Version
- 2019
- Platform
- Windows
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:
<tbody>
</tbody>
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.
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:
=A6 | =I9 | =AZ3 | =O12 | =L1 |
=AA4 | =J2 | =Q1 | =U9 | =V17 |
=B7 | =AA1 | =P2 | =N14 | =AZ6 |
=Z1 | =C8 | =G12 | =P32 | =B12 |
<tbody>
</tbody>
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.