Why not simply have your vlookup formulas in cells separate from where you
want to display your "static" results. Then make your "update request" a
Copy/PasteSpecial operation to put their current values where you want to see
them on the second sheet?

"ACCA" wrote:

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.