Static Vlookup

A

ACCA

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.
 
B

B Lynn B

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Crashes When Importing Data File 1
type mismatch error 7
Using VBA to copy data into another worksheet ??? 2
Auto update some spreadsheets inside a shared workbook and NOT others 0
Sheet Reference in vlookup 2
Vlookup Loop 1
Select Previously Selected worksheet (and/or select previouslyselected workbook) 5
Data posting in 2nd worksheet 1

Top