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)
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)