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,