At work we have spreadsheets that we call scorecards. They contain our reps
statistics on a monthly basis for various objectives they are expected to
meet. Some of the cells are protected and won't let us even select the
locked cells.

We are on our fourth template for the year and expect to get one or two more
before the scorecard is considered complete.

What I am wanting to do is create a macro that will allow me to transfer the
data from a previous version of the same scorecard to our newest one. All
the cells that are accessible in the new one are the same as in the old one.
I merely want to create a macro that will copy the data from the one sheet to
the other without doing it manually.

I can even provide the worksheets if necessary. Help!

Thanks,
Cheri