Copy data from one worksheet and paste into another worksheet

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?
 
J

Jim Thomlinson

Post your code... Also are you looking to basically append records to the end
of your history list or ???
 
S

stockton12

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

Top