I have office 2010
Originally I attempted to do this with excel, but the formula used made cpu hit 100%
I have uploaded a sample file excel file.
I can if needed upload 4 separate delimited text files.
Goal
Update data from Tab 2 using tab 1 as source, NOT including data unique to Tab 1 first field then output data to tab3 or to new data file.
then
for tab 4
I need to know what skus from Tab 2 is NOT in tab 1
Turns out some active skus are being ghosted that is why I need tab 4
the attached file has a password of
test
sample_sheetB.zip.