Comparing two excel files and copy Unmatched

Hello!

I am a newbie here and in VBA.

I have two excel files a "weekly" WB and a report with "main data" WB.

I need to compare "weekly" WB "Raw data" sheet Column A with "main data" WB "report" sheet Column E (starting from E6). If the data matching then I need to copy from "weekly" report "Raw data" sheet D column data (where the compared cells are matching) to "main data" WB "report" sheet column D.

Also if there are unmatched data then unmatched data needs to copy to the end of "main data" WB "report" sheet.

Any help would be appreciated!

Thanks!

Welcome to the Forum Peter. Can you attach a sample file with some dummie data to test on? To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Peter, though I think it would be best to attach an actual workbook with sample data. Maybe this?

Please Login or Register  to view this content.

Yes, it would be easier, but I needed to create a spreadsheet with sample data.

It is attached now and thank you!

Sample_CMO-FMO.xlsx

Does this help?

Please Login or Register  to view this content.

It works!

Thank you John!!

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.