At work, I have a protected worksheet that has individual cells that
are unprotected. However, protected cells surround each cell I'm
trying to paste values into. That is, empty columns and rows that were
used to format the worksheet were protected. There's A LOT (hundreds)
of data points that need to go into this protected worksheet and at the
moment copy/paste special is the solution. Macros could help, but this
process would be terribly repetitive to do and it just welcomes errors.
Basically, I want to semi-automate the filling-in of the unprotected
cells in a protected worksheet with data from another spreadsheet. I'm
stuck.

A simple example of what I'm talking about: SpreadsheetA contains the
values 1 through 5 in cells A1:E1 in Sheet1. I want to paste them into
Spreadsheet B (the protected one)into cells A1, C1, E1, F1, and G1 in
Sheet2. So, B1 in SpreadsheetA gets pasted into C1 in SpreadsheetB.

One final restriction to contend with: the unprotected spreadsheet must
start with empty unprotect cells and has to finish with values in those
cells.

Let me know if you have any ideas . . .