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.
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.