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 . . .

Jose,

Your statement:

"Macros could help, but this process would be terribly repetitive to do and it just welcomes
errors."

is entirely wrong. Macros are the only way to do this: writing the macro wouldn't take any longer
than pasting in this line a few hundred times:

Worksheets("Sheet2").Range("A1").Value = Worksheets("Sheet1").Range("A1").Value

and then editing it: the second line then becomes

Worksheets("Sheet2").Range("C1").Value = Worksheets("Sheet1").Range("B1").Value

and so on....

Unless your transfer of cells has some looping logic to it, then you are stuck with a line by line
approach.

HTH,
Bernie
MS Excel MVP


"JOSE" wrote in message
oups.com...
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 . . .

Sure as heck helps! I was heading in the wrong direction and your
response brought some clarity -- which is a good thing b/c I had my
head buried in a VB reference book. This is simple and a little
looping logic will make it run a heck of a lot smoother.

Bernie, I truly appreciate the help.

All the best,
Jose