Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Static Vlookup
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Static Vlookup
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
static array | Excel Programming | |||
"Static" Behavior without Static Defn | Excel Programming | |||
Static Row | New Users to Excel | |||
Static variable | Excel Programming | |||
Static Variables | Excel Programming |