|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Quote:
Thank you for the help! |
Tags |
vba code |
|
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 |