I am trying to transfer values from cells D1:D400 in worksheet2(ws2) to cells
B1:B400 in worksheet1(ws1). I only want the values to appear in worksheet1
and not the cell reference formula. One method is to copy cells form ws 2 and
do edit paste special-values but I am wondering if there is a way to put a
formula in cell ws1 B1 such as =ws2D1 then copy that down to D400. Is there a
way to do this and get the values only and not the formula =ws2 D2. I have
many columns to do and I am trying to avoid having to switch back and forth
from the various worksheets. I appreciate any suggestions.

--
Shooter