MS Excel provides the ability for cells in one worksheet to be linked with another worksheet. But we can create a link between two worksheets or workbooks to automatically updated data in another sheet if it first worksheets. We can link the worksheet and automatically. The link is a dynamic formula that pulls data from a cell of one worksheet to other worksheets by automatically updated that data.
We can link these two worksheets using the below method.
First of all, select the text cells, copy the text by right-clicking on any cell and select the copy option. You can also do this by the Ctrl+C shortcut key.
Then open the new blank document and select the cell where you want to paste the text.
Right-click on it and select the Paste Special option.
The new window is opened with a titled paste special. Look for the Paste link option and click on it.
If you change the text in one sheet it automatically updated into the second sheet.
