AlphaLolz
asked on
Substituting Lookup values for formulas in Excel
I need to bring over 3-4 columns of several hundred rows of data from one excel workbook to another. I can insert the vlookup formula in the target, but is there anyway in Excel to replace formulas with values in-place or do I need to create temporary working columns with the formulas and then do a copy-n-past from that into the target somehow.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.