View Single Post
 
Old 05-04-2017, 08:00 PM
Forum2000s Forum2000s is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: May 2017
Posts: 2
Forum2000s is on a distinguished road
Default VBA Newbie (Trying to write a code to copy and paste info from one sheet to another)

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
File Type: xlsm Team Weathers QA Form Test 6.xlsm (122.2 KB, 12 views)
Reply With Quote