All cells in a workbook referencing another cell
If we have a sheet in a workbook that we are replacing (moving data from old sheet to a new sheet, but changing layout), but has a lot of data referenced by other sheets in the workbook, how do we quickly see what locations in the workbook are referenced by that sheet's cells with data?
Our goal overall is to remove any references to the old sheet so that only the new references remain.
I'm aware you can click one by one and see where the referencing locations are in the other areas of the workbook, but if I want a quick view for the entire sheet of the referencing locations, can that be obtained?
0
Please sign in to leave a comment.
Comments
0 comments