VBA Correct formulas in multiple workbooks

[somliving]

Good Morning,

I have a workbook that has 50 worksheets (Master_File). I then made 48 copies of the workbook one for each project that my team is currently working. I know need to make corrections to formulas in particular cells, and I need to apply this to each workbook. I do not want to have to go into every workbook and correct 10 worksheets on 48 different workbooks when they are all the same corrections. Does anyone have any VBA code that would copy formulas from my "Master_File" and update those same formulas in the other workbooks? Any directions/advise is appreciated.

I have mader correction in my master_File to the following:

State of the Union!D29:D40
State of the Union!F29:F40
Rpt-Summary History!H12:H49
Rpt-Summary History!N12:N49
Rpt-Summary History!X12:X49
Rpt-Summary History!AC12:AC49
Loss To Lease!V15
Vacancy!d7
Vacancy!e7
Vacancy!f7
Vacancy!g7
Vacancy!h7
Vacancy!i7
Vacancy!j7
Vacancy!k7
Vacancy!l7
Vacancy!m7
Vacancy!n7
Vacancy!o7

And I could go on. As you see there are a lot of corrections and doing this in 49 different files is not proficient. I appreciate the help x10000

Thanks,

Jackie








Thanks,

Jackie

 

[jkpieterse]

I would try to devise a way to have just one workbook with logic and maybe 48 with just data and somehow link those together. Alternatively, have all of the data in the one workbook and use filters to show relevant bits. Otherwise you will find yourself in a continuous maintenance nightmare.