Date not updating in excel worksheet
However, if I understand your request, you'd like to hard-code the value result of a formula in one cell into another cell. The only way you can do this (other than by by writing out by hand) is to run a VBA subroutine. something of this sort meaning if a certain condition evaluates to true then write the result as work done in A5. and this particular formula is copied right down the excel sheet. meaning B6 will have formula ($a="yes", A6="work done") . Please help urgently quote: Originally posted by hakimk Hi Everyone, I am having a formula in Cell B5 and I want to put the result of this formula in Cell A5. Cell A5 should contain the result of formula written in B5. Then I want to copy the same formula down to other cells . Thanks Hakim In that case you cannot do specifically what you want with Excel sheet functions alone. Clearly these values will change as precedant cells change. To lock the values in these cells: 1) Select the row / column of formulae cells 2) Copy (Press Ctrl c) 3) Select a blank cell in the adjacent row / column 4) Paste Special, Values (Edit - Paste Special...) - this will create a row / column of hard-coded outputs of the row / column of formulae at the time you did this. The code can be either linked to a button, or run from a event procedure. The actual mechanics of creating this chart are incidental to the discussion, but we’ll use the following simple data and chart (named “Chart 1”, the default name of the first chart created in a worksheet). In this example, the range B14: C16 is used to hold primary X and Y axis scale parameters for the embedded chart object named “Chart 1”.
So what I want is whatever is the value inserted in the A4 Column by B4 should remain as it is. You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. Hi Everyone, I am having a formula in Cell B5 and I want to put the result of this formula in Cell A5. Cell A5 should contain the result of formula written in B5. Then I want to copy the same formula down to other cells . Thanks Hakim I'm not quite sure I understand the motivation for the specific functionality you are requesting. Something like this should do the trick (replace "A5" and "B5 for different cells as required) Clearly each time the formula in the first cell eveluates to a different result the hard-coded value in the second cell would go "out of date". If you'd like a dynamicly updating hard-coded cell you'll need to use a worksheet event along the lines of: Thanks For replying I will explain you my problem once again I want: when i type in B5 Cell : =if ($a="yes", A5="Work Done") ...
Search for date not updating in excel worksheet:
These properties can be set equal to constant values, to VBA variables, or to worksheet range or named range values, as illustrated in this code sample: If you have a Line, Column, or Area chart with a category-type X axis, you can’t use the properties shown above.