Can you paste to protected spreadsheet and skip over locked cells?
I have a spreadsheet that has some cells locked and others that are
not. I need to refresh the data on the page every month. I want to be
able to copy the new data and paste it into the spreadsheet. The catch
is that I do not want the locked cells to be changed. Is there a way
to paste so that Excel will ignore those locked cells and skip over
them? At this time it says that cells are locked and does not paste
anything.
Thanks
|