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.
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. Read More