| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to trace a cell? Which cells use a special cell in formulas?
Dear all,
Just consider that i have a cell "B1". And i want to find which cells use this cell as a data in total workbook. eg. formula C5 = B1*3 formula D2= B2 + B6 - B1 So i just want to find C5 and D2, becuse they use B1 as data. Do you know how? Regards, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to trace a cell? Which cells use a special cell in formulas?
<tools<Formula Auditing<Trace Dependants
"SupperDuck" wrote: Dear all, Just consider that i have a cell "B1". And i want to find which cells use this cell as a data in total workbook. eg. formula C5 = B1*3 formula D2= B2 + B6 - B1 So i just want to find C5 and D2, becuse they use B1 as data. Do you know how? Regards, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to trace a cell? Which cells use a special cell in formula
Thank you bj,
It is cool but is there any way to write these cells any place? regards "bj" wrote: <tools<Formula Auditing<Trace Dependants "SupperDuck" wrote: Dear all, Just consider that i have a cell "B1". And i want to find which cells use this cell as a data in total workbook. eg. formula C5 = B1*3 formula D2= B2 + B6 - B1 So i just want to find C5 and D2, becuse they use B1 as data. Do you know how? Regards, |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to trace a cell? Which cells use a special cell in formula
You might be able to do it with code, but I do not know how.
"SupperDuck" wrote: Thank you bj, It is cool but is there any way to write these cells any place? regards "bj" wrote: <tools<Formula Auditing<Trace Dependants "SupperDuck" wrote: Dear all, Just consider that i have a cell "B1". And i want to find which cells use this cell as a data in total workbook. eg. formula C5 = B1*3 formula D2= B2 + B6 - B1 So i just want to find C5 and D2, becuse they use B1 as data. Do you know how? Regards, |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to trace a cell? Which cells use a special cell in formula
There is my Formula Map vba code here ...
http://makeashorterlink.com/?D2151176C -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "SupperDuck" wrote in message ... Thank you bj, It is cool but is there any way to write these cells any place? regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing (or counting) cells until there is a blank cell | Excel Discussion (Misc queries) | |||
| Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
| Copy and Paste Special (Formulas) pastes cell value if numeric | Excel Discussion (Misc queries) | |||
| Cell Formatting Conditional On Other Cells Fill Color? | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Linear Mode
