Autopopulate data in one sheet (using formula's) based on data update in another sheet.

Copper Contributor

Hi, I need to Autopopulate data in one sheet (using formula's) based on data update in another sheet.

mjoon_0-1716220793788.png

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.

1 Reply

@mjoon 

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.