copying data from one sheet to another

[CADIM2013]

Hello

i dont know much about using macros in excel. i have two spreadsheets one called "Order Form" and the other "Update". order details are entered into "order form" but i would like to copy the details into "update" so i can keep a running log of all orders placed. at the present when the order is sent over to England the info in "order form" has to be printed out and kept but this ends up with loads of sheets and is too hard to keep track of what has been ordered and what has arrived/not arrived yet etc. if i could get the order details copied into the "update" sheet would mean i have a list of all orders and can then search or filter when needed. sometimes there will be more than one row of data in the "order form". can i do this by using a command button which will also automatically delete the info in "order form"?

[arlu1201]

Sure, this can be done easily. Why dont you attach a sample of your file so we can assist you further. Ensure that your sample file has the same format as the original file, and you do not need to retain the sensitive data.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[CADIM2013]

Order Book.xlsx

Thank you for your quick response. Hope this is ok for you

[arlu1201]

What should be filled in columns I-J-K?

Do you want the data from the FORM sheet to be cleared once the data is copied to the UPDATE sheet?

[CADIM2013]

I-J-K in the UPDATE sheet are entered by myself - no need to worry about this, sorry. yes if the data could be deleted this would be great thanks

[arlu1201]

One more question - would there be any data in any cell of the FORM sheet which will help us to identify that it is the last row to be copied?

[CADIM2013]

No, is it needed?

[arlu1201]

It is to help the macro understand which is the last row which needs to be copied. Even if it is after the row to be copied, i can get it to work.

[CADIM2013]

oh ok. "order complete" or something like that. it doesnt realy matter - if you want to do it own way as you understand what you need to make it work, i can work around it

[arlu1201]

No no i meant is there some text like Total or End of Order or something in the FORM tab as the last row below all the rows? So the macro can identify that the row before it is the last row to be copied and it can then clear the contents of the FORM tab.

[CADIM2013]

there isnt at the minute but we can use something like that. so if i type End of Order under the last row it will know to stop?

[AB33]

The code loops until the last row minus 6 in sheet form.

The code works if the heading on both sheets match( Exact)

[CADIM2013]

Thanks You AB33 for the workbook. works very well and saves a lot of hassle!! sorry i am only replying now but i am only back at the office today. thanks again