Excel Macro To Merge 2 information

IN PROGRESS
Bids
1
Avg Bid (USD)
$30
Project Budget (USD)
$30 - $250

Project Description:
Here is what I am looking for, and need it as quick as possible within 24 hours if possible. I need a macro (VBA Code) to copy the contents of one column in the source workbook to the destination workbook. This isn't as simple as a cut and paste. I need it to validate and compare the files based on contents on 2 other columns similar to a mail merge function.

1. There are 2 excel workbooks.
2. The source one where I want to put the Macro is named TOR_PD_Overlay.
3. The destination or target workbook is named Target_2010_Mail.
4. The source workbook has a worksheet named Remodels.
5. The target workbook also has a Remodels worksheet.
6. Both worksheets have columns named St# and Start Date.
7. St# is column D in both source and target worksheet.
8. Start Date is column M in the source worksheet and column N in the target worksheet.
9. Need to create a new column (AL1) named "P&D Completed Date" on target worksheet.
10. Column N in the source worksheet has the contents we want to copy ("P&D Completed Date") and merge into the new column AL in the target worksheet.
11. The macro needs to verify if there is an entry in column N and if so, copy and paste it into the target worksheet matching it against the St# & Start Date columns.


Note, while the stores are in order on both samples attached, they may not be every week. The system will update the target workbook and the source is maintained by someone and the "P&D Completed Date" will be updated by that person that is why it needs to scan and compare between the two other columns. The person updating the Source file should be able to run the macro to update the weekly generated target workbook.

Skills required:
Microsoft
Additional Files: TOR_PD_Overlay.xlsx Target_2010_Mail.xls
Hire yassen5547
Project posted by:
yassen5547 United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.