compare 2 workbooks

I have two workbooks M.xlsx and Lable DB.xlsm. I need VBA to compare this two workbook column A which has matching values, and when values are matched copy the corresponding Col B and Col C datas from Lable DB.xlsm to the matched value of M.xlsx workbook. Some condition: I will place both...

Hello folks, I am not an expert at excel, so not sure how to resolve this issue. I have two excel worksheets: File 1: Subset: This file has a subset of employees with various details including training status such as in-progress, completed, etc. File 2: Full-Pop: This file has a complete...

Hi all, Introduction: I am trying to find text differences b/w two PDFs via Excel. The PDFs I am comparing are older and newer versions of the Preferred Drug List (PDL) that state Medicaid programs publish 2-4 times a year. My team's current process is to compare the older and newer versioned...

Hello All, I am new to the forum and have been using VBA in a limited fashion for about half a year. However, it is my goal to get a lot better at it so here I am. My first question involves comparing values between two different workbooks using a macro. Specifically I would like to: Look in...

good day everyone, I need help to compare a few columns in one workbook to another few columns in another workbook. vba or just simple conditional formatting, doesn't matter to me. the following is what I am working with. book1: is a name list with position number. column A has position...