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 values in another sheet in the same excel worksheet to be updated (they have formula to refer these cells).
Any suggestions on how to achieve this? Thanks.
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.
