I have formulas all over my worksheet. I will, eventually, have many
worksheets that I will be merging. At that point, the formulas (vlookups,
cell references, etc.) will no longer work. Is there a way to just put the
answer in a cell instead of showing the formula? (similar to the "paste
special....value" without having to copy and paste :-).