Add Running Formula One-By-One when info entered in adjacent Column in the same Row.
Basically, I want to insert formulas in three different columns based on entering information in 2 Different columns.
When I enter information in the column B then I want a formula to be be entered in the same row of the column A..the
column A is the column for the Sr,No where the Automatic Serial no will get generated leaving inter-row space between any
entries in the Column B.
Column A and Row C2 onwards formula:
Ex: Cell A2 =
Now as seen the formula is a locked type of formula with the cell $B$2 and the End Range as Running...
after the calculation is done I want this to be immediately copy pasted as value in the same cell..
On the same
grounds, I also want to have 2 different formulas to be entered in the Columns C and Column D whose values are dependent on
the entry of information in the Columns A as well as Column E.
Let me start with the Column C whose value depends
on the information entered in the Columns A and Column E i.e. when information is entered in Cell B2 then the cell C2 and
Cell C3 should have the formula as ...
Column C =
So, I want the formula to be entered in 2 rows in the column C after checking for the information in the Columns
A and Column E.
In the Column D, I want the below formula to be entered which is again based on the Columns And
Column D =
Both the values derived in the column C and Column D should be immediately copy-pasted in the same cells...
I suppose this VBA code has to be entered in the WorkSheet_Change Module..