ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   TRACKING CORRECTLY LINKED CELLS! (https://www.excelbanter.com/excel-programming/283163-tracking-correctly-linked-cells.html)

Jay Dean

TRACKING CORRECTLY LINKED CELLS!
 

In my excel workbook, cells in SheetA link to cells in SheetB.These
links are many.
The problem is that occasionally, I find that some of the cells in
SheetB are linked to the wrong cells in SheetA.

Question- I need a way to check that the cells in SheetB are linked to
the right cells in SheetA. I tried using Ctrl+~ but because the linked
cells are too many and the formulas are sometimes too long, manually
verifying the cell links is an eye-strainer. Are there any better or
easier ways? Any help would be greatly apppreciated. Thanks.

Jay Dean

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


All times are GMT +1. The time now is 12:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com