Code to copy and paste values on a sheet to another sheet

Hello all,

I'm new to using VBA but I've been trying to learn because I need to create a QA Call Monitoring form for a call center; the workbook needs to have a database sheet. I need the information in the cells on the QAForm sheet, to copy to the QADatabase sheet, and clear the QA form after. Can someone take a look and tell me what I am doing wrong?

I'm using Excel 2010.


This is what I've entered:

Please Login or Register  to view this content.

Hi Forum2000s
Welcome
Start by changing this:

Please Login or Register  to view this content.

EDIT:

I also notice that there is no Sheet named "QADatabase"
Sheet5 is "Score"

EDIT:
I'm using excel 2007 so can't replicate your code....Not working

sintek,

Sorry about that. I added the correct file.

I would really appreciate any input anyone can give me to resolve this issue with the code I'm trying to write: It doesn't copy at all.

This will get you started...

Please Login or Register  to view this content.

Originally Posted by sintek

This will get you started...

Please Login or Register  to view this content.

Awesome! I was so frustrated with this.


Thank you for the help!

All good

Substitute with this to clear after

Please Login or Register  to view this content.

If you are satisfied please mark thread as solved and add rep point