In Progress

Excel Macro To Merge 2 information

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: Microsoft

See more: mail merge excel macro, what is date entry, we excel, to p, mail merge macro, information week, excel mail merge macro, what is vba in excel, what is vba, what is macro in excel, verify information, new excel, microsoft vba, microsoft macro, microsoft excel VBA, microsoft excel mail merge, excel compare two worksheets, vba excel, vba excel macro, vba compare, vba code excel, VBA and excel, validate excel, simple macro, scan copy

About the Employer:
( 3 reviews ) Auburndale, United States

Project ID: #643296

Awarded to:


Please see your PM

$30 USD in 0 days
(3 Reviews)