Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data from one worksheet and paste into another worksheet
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data from one worksheet and paste into another worksheet
Post your code... Also are you looking to basically append records to the end
of your history list or ??? -- HTH... Jim Thomlinson "stockton12" wrote: 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data from one worksheet and paste into another worksheet
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").ClearConte nts Worksheets("Template").Range("G15:J15").ClearConte nts "Jim Thomlinson" wrote: Post your code... Also are you looking to basically append records to the end of your history list or ??? -- HTH... Jim Thomlinson "stockton12" wrote: 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data from one worksheet and paste into another worksheet
Maybe this page will help you
http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "stockton12" wrote in message ... 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").ClearConte nts Worksheets("Template").Range("G15:J15").ClearConte nts "Jim Thomlinson" wrote: Post your code... Also are you looking to basically append records to the end of your history list or ??? -- HTH... Jim Thomlinson "stockton12" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy & paste cells fr open worksheet then close the worksheet | Excel Programming | |||
How do I copy & paste only the unhidden data on a worksheet ? | Excel Discussion (Misc queries) | |||
How can i copy and paste data when there is a filter in the worksheet.... | Excel Discussion (Misc queries) | |||
copy data from one worksheet and paste into another workbook | Excel Programming | |||
Copy worksheet and paste it in New workbook, all data except Formulas | Excel Programming |