Copy rows where date is equal TODAY and move them to another workbook

Yes its possible. Why dont you give some more details with the help of a sample file?

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.

In the attached file(Form.xls) I have there date called field which when the date is equal to "8-24"(TODAY) all that have date called today will be transferred to an existing or new workbook, all rows included, and I will do that for all the sheets (client1, client2 and client3)

Please Login or Register  to view this content.

I found this code and tried to play with it, the code will transfer the copied rows to "transaction.xls" then will delete them on the main form. When I ran this code it gives me many errors.

Please guide me.

Thanks
Brian

Is this question the same as http://www.excelforum.com/excel-prog...workbook.html?

Please ensure you do not create duplicate threads in future. You can bump a thread if you do not get replies.

Also, marking it as "Solved" will continue to keep it as duplicate, so that doesnt help anything.

Thread closed.