I want to know why my formulas/functions are not automatically updating.
1. My worksheet has 223 rows of data entered of the 1,048,576 rows.
2. There are formulas/functions in columns G through AE.
3. When I go to row 224 to input data, only Column L automatically add the formula/function.
4. Therefore, I have been having to copy and paste the formulas/functions to the current cells.
5. That is, select G:AE, click the little black box and drag to the current cell.
The below code I found on the web inserts a row first and then the formulas/function on another line. Also, I have to find just the right spot in a cell above to double click. Meaning, if I double click on the current row, it does nothing.
Any idea why only Column L is updating automatically?
Bookmarks