Copy data from one worksheet and paste into another worksheet

  • Thread starter Thread starter stockton12
  • Start date Start date
S

stockton12

I have a spreadsheet that is used to process invoices. It is a standard
template that has drop down features that I do not want to change. I have
been asked to create a history of all the payments that have been processed
on this spreadsheet. I have found a code to copy the information that I
need, however, I need one that will look and see if the row is not null, then
it will go to the next row.

Any suggestions?
 
Post your code... Also are you looking to basically append records to the end
of your history list or ???
 
Yes, i am looking to append records to the end.

Sub Button4_Click()

With Worksheets("template")
.Range("G15").Copy
Worksheets("Payment").Range("a1").PasteSpecial
End With


Worksheets("Template").Range("Q19").ClearContents
Worksheets("Template").Range("P38:Q49").ClearContents
Worksheets("Template").Range("G15:J15").ClearContents
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Excel VBA Copy and Paste from external workbook data to central worksheet 1
VBA copy and paste data 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
VBA - Copying a Certain Colored Row to Paste in Another Worksheet 1
Combining Multilple Worksheets Into One 6
Copying and Pasting Macro from one worksheet to another 2
Copy-Pasting row into exact same row on specific other worksheets 5

Back
Top