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 would really appreciate any input to help get this to work.

I'm using Excel 2010.


This is what I've entered:

Sub

erw = QADatabase.Cells(1, 1).CurrentRegion.Rows.Count + 1

QADatabase.Cells(erw, 1) = Range("B3")
QADatabase.Cells(erw, 2) = Range("C3")
QADatabase.Cells(erw, 3) = Range("D3")
QADatabase.Cells(erw, 4) = Range("E3")
QADatabase.Cells(erw, 5) = Range("F3")
QADatabase.Cells(erw, 6) = Range("G3")
QADatabase.Cells(erw, 7) = Range("L3")
End Sub

Attached Files

Team Weathers QA Form Test 6.xlsm (122.2 KB, 12 views)