Forum Discussion
Autopopulate data in one sheet (using formula's) based on data update in another sheet.
Hi, I need to Autopopulate data in one sheet (using formula's) based on data update in another sheet. When i update Values in Col 1, Col2 , Col 4, Col5, Col 6 on this current sheet - i want va...
As long as Calculation Options on the Formulas tab of the ribbon is set to Automatic, formulas referring to other cells should update when those cells change, without any intervention.