Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Daily Updating
I am auto-updating a daily productivity sheet for employees, and I
need to know how to do the following: =IF($B$1<1,"",IF($B$1=1,VLOOKUP($A4,$A$3:$B$68,2,F ALSE),????????)) I need to know what I can put in the ???????????????? part for the false statement in order to have the value that is currently stored in the cell remain the same, without creating a circular reference. Is that possible? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Daily Updating
On 29 Aug, 17:02, Matt Russell wrote:
I am auto-updating a daily productivity sheet for employees, and I need to know how to do the following: =IF($B$1<1,"",IF($B$1=1,VLOOKUP($A4,$A$3:$B$68,2,F ALSE),????????)) I need to know what I can put in the ???????????????? part for the false statement in order to have the value that is currently stored in the cell remain the same, without creating a circular reference. Is that possible? Not with a formula (unless someone knows different!) but as this is a programming group, do it with VBA - use the OPEN event of the workbook (presumably) and test the value of B1 to set the appropriate value or formula in your cell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET | Excel Discussion (Misc queries) | |||
Updating Daily with excel spread sheet | Excel Discussion (Misc queries) | |||
Linking Daily Worksheet To Daily Invoice Total | Excel Worksheet Functions | |||
updating data daily for a wk/month total | Excel Discussion (Misc queries) | |||
When updating a worksheet, how do I create a link updating the sa. | Excel Worksheet Functions |