Resolved: I can't comprehend what u did in the last scene
Can u explain the last scene a bit?
In the last part of the video, we show you how to replace the references of an external sheet with Find and Replace.
You obtain such references when you link a cell in your current sheet to another Excel file. Sometimes you will have the same source sheet in your current workbook. To update the references, you need to remove the references to the external file. Everything else is identical. This is how Find & Replace can help you.
Hope this helps!