A feature to find same text (tag) in a target document (without using hyperlinks) based on selected cell in source sheet
Usually in testing and may be in other areas, we map our test cases (in source workbook) to test conditions ( in target workbook). The available options to give reference or hyperlinks is not only cumbersome but is also error prone if changes are made in target workbook. I created a simple macro today that takes the target file location reference in source file and than based on which cell a user has selected in source sheet, by clicking on macro, it will take me to the cell with same tag name in target sheet. What it means is we are avoiding cumbersome hyperlink method to map each cell and can now rather find all linked tags in another workbook just by a simple reference to document and based on cells location in source. I think a similar feature may find usefulness in many other areas as well?