Copying data using key column and excluding #N/A
Posted on 2013-01-24
I want to copy data from one workbook to another using a key column that exist in both.
So far I've tried using VLOOKUP but I'm not sure it is the best way.
I have a button that runs a macro. First I select the cells I want the formula in:
Selection.FormulaR1C1 = _
This works fine, BUT... I want the values in the cells, not the formula itself. And I want to clear the #N/A that I get in the cells if the formula has no match.