Skip trying to paste over locked cells when pasting over a whole column

Hello,

I have a formatted budget vs actual income statement that has subtotals in the appropriate spots. I would like to be able to paste over the entire column with updated data, but not write over the formulas. For instance, in one spreadsheet I have the data for the month of June and in another I have the data for the month of July. Both have the same number of rows, but are formatted slightly differently. I want to be able to replace the June data with the July data.

My first thought was to lock the cells with the formulas, protect the sheet and then paste over the entire column, but I get the following error:

The cell or chart that you are trying to change is protected and therefore read-only.

To modify a protected cell or chart, first remove protection using the Unprotect Sheet command (Review tab, Changes group). You may be prompted for a password)

Any suggestions?

Thank you!