automatically update referenced cells from one sheet to another in excel

Copper Contributor

After linking source & destination worksheet, if i insert a new row or column in the source worksheet how to get auto update in the destination worksheet

1 Reply

@EmilyLu Can you explain in a bit more detail how you "link" the two sheets? Can you attach a sample file? Please, no confidential data and only a few rows to illustrate what you want to achieve.