ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I display a list of all cells referencing a particular cel (https://www.excelbanter.com/excel-worksheet-functions/108837-how-can-i-display-list-all-cells-referencing-particular-cel.html)

kPod

How can I display a list of all cells referencing a particular cel
 
I have a spreadsheet with lots of (textual) data that we're using for process
mapping. What I'm trying to do is establish a formula that will display a
list of ALL cells in the workbook that are referencing a particular cell?
For example, in "Sheet 1" I have a list of potential 'Inputs.' Whenever an
'input' is required for a process, we use the equals function to reference
that input from "Sheet 1." This allows us to change the wording of the input
and have it update automatically throughout the workbook. Can I use a
formula to display every cell in the workbook that is referencing that cell?


All times are GMT +1. The time now is 06:51 AM.

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