PDA

View Full Version : Two Workbooks - Search for Values in Workbook 2, Copy and Paste in Workbook 1



CC268
01-27-2017, 08:18 AM
Worked on this all day yesterday, but couldn't get it to work. Going to try this again and keep it simple - here is what I want to do:

Two Workbooks: one opened already (ThisWorkbook) and one opened through Application.FileDialog(msoFileDialogOpen) (we will call this Workbook 2)

1. If Column K is blank in ThisWorkbook."Sheet1" then search for values in Column M and Column P in Workbook 2."503 Sundry", Column B and G respectively.
2. If values match in Workbook2."503 Sundry" then copy values from Column H and Column I and paste into ThisWorkbook."Sheet1", Columns I and K respectively.

Cross-posted at Mr. Excel (https://www.mrexcel.com/forum/excel-questions/987992-two-workbooks-search-values-workbook-2-copy-paste-workbook-1-a.html#post4740379)