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,

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,

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,

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,

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