Apologies if posted elsewhere, however, I have been unable to successfully locate how to perform the below action.
I have Two Workbooks, WB1 & WB2, both have no more than 4000 line items in each workbook.
In WB1 I have entries within Column G that I need to bring over into WB2.
I am trying only to pull from WB1 into WB2, those which have exact matching values from Column B in WB2 & Column A in WB1.
AAm explaining this question right? I'm at wits end trying to figure this out, please help!
I have Two Workbooks, WB1 & WB2, both have no more than 4000 line items in each workbook.
In WB1 I have entries within Column G that I need to bring over into WB2.
I am trying only to pull from WB1 into WB2, those which have exact matching values from Column B in WB2 & Column A in WB1.
AAm explaining this question right? I'm at wits end trying to figure this out, please help!