Sleeper: Copying Data between Workbooks

[xl_psychic]

Hi All,

Can anyone help me with a code to do the following:

There is workbook in which the user enters in data.
In Column E he/she enters in the Date.
In Column J he/she enter in the Process
There is an Export Data Command Button on the Worksheet.

Things that need to happen when this button is clicked are:

* Code should ask the user for the date and Process for which the data needs to be copied.
* After getting the date and Process, compare and copy entire rows (suppose B:AA) which match the date in column E and Process in Column J with the ones supplied by the user
* paste this data to the worksheet (of the name as that of the Process) of another workbook (with the same name as this workbook) in another folder.
* whilst copying it to another workbook the code should check for the next available blank cell, say B42 and start pasting the copied content from there on.

Help Appreciated.

[Paleo]

Hi,

check if this helps:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=359
http://www.vbaexpress.com/kb/getarticle.php?kb_id=318