VBA Newbie (Trying to write a code to copy and paste info from one sheet to another)

Forum2000s · #1 05-04-2017, 08:00 PM

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

NoSparks · #2 05-05-2017, 07:39 AM

You're not fully qualifying things in telling Excel what to work with. Try like this...

Code:

erw = Sheets("QADatabase").Cells(1, 1).CurrentRegion.Rows.Count + 1
Sheets("QADatabase").Cells(erw, 1) = Sheets("QAForm").Range("B3").Value
'etc

Forum2000s · #3 05-07-2017, 04:51 AM

Quote:

Originally Posted by NoSparks

You're not fully qualifying things in telling Excel what to work with. Try like this...

Code:

erw = Sheets("QADatabase").Cells(1, 1).CurrentRegion.Rows.Count + 1
Sheets("QADatabase").Cells(erw, 1) = Sheets("QAForm").Range("B3").Value
'etc

Awesome! I was so frustrated with this.

Thank you for the help!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copy a row and paste the row into another sheet more then one time:macro	waqar1239	Excel Programming	1	04-07-2017 09:57 AM
How to copy excel sheet withe HEADER and Paste into new sheet?	cloudforgiven	Excel Programming	6	01-05-2017 07:30 PM
Open csv files & copy and paste info into master file	gbaker	Outlook	9	04-22-2016 11:02 PM
copy checkbox string and paste it in excel sheet	MOHAMMEDSALMAN	Excel Programming	7	10-29-2015 03:50 AM
Newbie to excel for starters, needing to transfer info from sheet2 to universe sheet.	rogcar75	Excel	0	08-12-2014 07:21 AM