Automatic copy and insert row to other sheet after input and click button

[antoni]

Hello Bos, can u help me please ??
When I want entry the data like name, address and etc in sheet1 and then I click a button at sheet1, so in sheet2 aotumatic insert the data (copy) from sheet1 and then in sheet2 automatic insert row after get the data from sheet1 (button1.click).
How can do that ??
Sorry my english grammar is not so good..

[Roger Govier]

Hi

The following code will copy the contents of row 2 from Sheet1 to the next available row on Sheet2. It assumes that row 1 on both sheets is a header row, and the data entered on Sheet1 takes place in row 2

The last line clears the entries on Sheet1 ready for the next input. Comment out this line if you don't want the entry cleared.

Please Login or Register  to view this content.

[antoni]

Thank's for your help Mr. Roger..
it's very nice code and running with succesfully for my worksheet.
Success for u Bos !!!
But, how can insert data from sheet1 to sheet2 accordance with the invoice number ?
Example :
On sheet1 entry the data like customer name, Qty and the invoice number. Sometimes we entry the data, invoice number is not sequential. So my question is : How we can insert the data from sheet1 to sheet2 accordance with the invoice number ? but the invoice number is ready on sheet2.

Thank's before..