Saving data to a second sheet

I'm working on a quality scorecard for a contact center in excel


The sheet works fine right now to score calls, etc., but the next step
is to save the data somewhere.

So, I'm trying to save the data into rows on another sheet.

In more detail, what I'm hoping to do is add a "save" button to the
bottom of the scoring sheet that does the following:

Copies (for example) cells c1, c2, c3, c4, c5, d7, e7 and e11 to a
second sheet and puts that data in rows so that row 1 would look like
this:
Cell A1 contains the data from sheet1, cell c1.
Cell B1 contains the data from seeht 1 cell c2
and so on.

Here is what I did:

Please Login or Register  to view this content.

What happens with my version is that range 1 copies perfectly, but the
rest do not.


Can anyone point me in the right direction please?
Thank you.

Hello jakin,

Welcome to the Forum!

Here is shorter version of your code. You can change the sheet names in the code if you need to. They are marked in red.

Please Login or Register  to view this content.