Macro to paste formula to selection that replaces a formula with a named range.

Hi

I’m very new to Macro’s and have gotten by, by cutting and pasting from threads on the internet. This one has me stumped. I am trying to select 5 adjacent cells in a spreadsheet and insert a different cell into each cell. The Formula is simple but refers to a named range of cells above.

I am updating the formula on a large number of existing spreadsheets which contain the same formula but with a different number. When I copy and paste these cells to update a spreadsheet I get a message that says “The sheet you want to copy to contains the name NDISBILL which already exists on the destination worksheet. Do you want to use this version of the name. Click Yes to confirm… I have to click yes 5 times as it cycles through the change to the adjacent cell in the selection.

This is what I need to put into each cell from left to right on the same row across 5 columns.

Column G
=SUM(CHECKBILL1*1.4285)

Column H
=SUM(CHECKBILL2*1.4285)

Column I
=SUM(CHECKBILL3*1.4285)

Column J
=SUM(CHECKBILL4*1.4285)

Column K
=SUM(CHECKBILL5*1.4285)

Any help would be greatly appreciated as at the moment I’m having manually update each workbook by flipping between a workbook I’m copying from and then copying into another workbook.

Hi - thanks for the quick response. That would work fine. I'd like to put that into a macro as I'll get it to remove the password, change the formulas and then re apply the password.

I'm not to sure how I would write a macro for that?

yes it's the same so I'll give it a try - thanks