Macro to change formulas quickly on several worksheets.

[taylorsm]

I have a workbook we use for to keep track of scores and such. In one cell I have it automatically keep score. However, during the last update, pages 3-15 have the same formula as page 2. So they all reflect that page's score (Cell L2). Same issue with the cell that tracks the number of errors (Cell L3). The L2 cells should have the formulas listed below.

I have a hundred workbooks or so that need fixed. Can I do a macro that runs on the open workbook and matches sheet name and then pastes the formula into that cell? If someone can help with the L2, then I can easily adjust to do the L3 myself.

Please Login or Register  to view this content.

[taylorsm]

If no one is available to help create, can you advise if anything is wrong with this?

Please Login or Register  to view this content.

[Sequoyah]

Hi taylorsm,
just a beginner suggestion to insert formulas on all workbooks in a folder, try this code (backup files before testing):

Please Login or Register  to view this content.

[taylorsm]

Hey Sequoyah, thanks! I thought about the folder option, but each workbook is in an employee's folder. so I would have to go drag it out and drag it back. Now if I can get it to ignore the file name unless it contains "September 2017" then I can run it farther up the file tree and it should work.

[taylorsm]

I receive a method 'Open' of object 'Workbooks' failed error. my path is correct.