Your solution did excatly what I wanted, but it is also changing the formula on the existing worksheet as well. I need for the original worksheet to maintain all formulas and the "new" worksheet to have the combination of formulas and values.

Thanks for the help. This site is great.