This is what I'm trying to do,
1. I have two workbooks, each with data numbered 1-?.
2. I need to have a function that does this:
(workbook 1, cell a2)=10,
if (workbook 2, cell a2)=10 also, then it inserts (w2, cell b2) into (w1,
cell b2).

And on and on down the line... Without having to enter the formula for each
individual row as I have about 2000 rows at this point...

Is there such a formula? Can it be done? It's made my head hurt so far
trying to figure it out. Thanks!