how to find cells that refer to data in other cells in excel
Lets say I have some number in cell A1. lets say, cell x4 and ab200 have
forumalas that use the number in cell A1.
If I didnt know what cell used data in cell A1 to determine its value, is
there anyway to find which cells in an excel file refer to a cell to
determine its value. I am looking for a fuction say "find_cell_reference"
which takes in the argument of a cell for which references are to be found.
so i would type something like:
find_cell_reference(A1)
and it will return something like "x4 and ab200"
Thanks
|