PDA

View Full Version : Sleeper: Copying Data between Workbooks



xl_psychic
03-21-2005, 06:00 AM
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
03-24-2005, 04:58 PM
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