I have 2 worksheets within a workbook with the 1st worksheet performing some
calculations. What I would to do on the second worksheet is to use Vlookups
to pull data from certain columns from the 1st worksheet but not update the
data being pulled when the data is changed in the 1st sheet unless I request
for it to be done. Is this possible without messing around with the
auto/manual calculation settings? Thanks in advance.