Replacing Multiple Cells In Multiple Spreadsheets

[FarPo]

Hi everyone,

I am currently struggling with a task where I have about 40 excel files containing 2 spreadsheets, a data spreadsheet and a calculator (in all the 40 files the names of the spreadsheets are the same). The calculator takes information from the data spreadsheet and does the appropriate calculations. I've been told that a few formulas and texts need to be changed in all the calculators. I could just open each file and copy-paste the required changes but while possible, it isn't very efficient and will take a lot of time. So my main question is, what would be the best way to approach this task? I assume VBA will do but I have very minimal experience with VB and non with VBA.

Any help and advice would be highly appreciated,

Thank you!

[TMS]

Being realistic, it would probably take longer to draft and test a bespoke VBA solution than it would for you to edit each of the workbooks. That probably depends on how many formulae need copying and pasting.

I would suggest that you update the first workbook, then open, copy the formulae, save and close each of the other workbooks. Tedious yes, libel to human error, but, if you take it steady, easily doable.

That said, it shouldn't be that hard but you'd need to isentify the location of the workbooks and list all the cells and the new formulae.