Cell Reference Macro
 

I have a financial model with all of my inputs on tab A that populates
financial statements on tabs b, c, and d. Does anyone know of a way or have
a macro that would in some way highlight the cells on tabs b, c, and d that
are direct cell references to a line item on tab a. Thanks in advance for
your help!

Cell Reference Macro
 

Try the below

2003: Menu ToolsFormula Auditing
2007: Menu FormulasFormula Auditing

Trace Precedents will show arrows to cells which are referenced in the
formula

Trace Dependents will show arrows to cells which are affected by the
selected cell

PS: In 2003 for regular use you may enable the formula auditing toolbar from
'Show Formula Auditing Tool Bar'

If this post helps click Yes
---------------
Jacob Skaria


"Scott" wrote:

I have a financial model with all of my inputs on tab A that populates
financial statements on tabs b, c, and d. Does anyone know of a way or have
a macro that would in some way highlight the cells on tabs b, c, and d that
are direct cell references to a line item on tab a. Thanks in advance for
your help!

Cell Reference Macro
 

I know how to use the formula auditing tools, but was hoping for something
quicker than tracing through each one of them individually since there are
literally thousands of lines. I was hoping for a way to do it automatically.
Thanks!

"Jacob Skaria" wrote:

Try the below

2003: Menu ToolsFormula Auditing
2007: Menu FormulasFormula Auditing

Trace Precedents will show arrows to cells which are referenced in the
formula

Trace Dependents will show arrows to cells which are affected by the
selected cell

PS: In 2003 for regular use you may enable the formula auditing toolbar from
'Show Formula Auditing Tool Bar'

If this post helps click Yes
---------------
Jacob Skaria


"Scott" wrote:

I have a financial model with all of my inputs on tab A that populates
financial statements on tabs b, c, and d. Does anyone know of a way or have
a macro that would in some way highlight the cells on tabs b, c, and d that
are direct cell references to a line item on tab a. Thanks in advance for
your help!

Cell Reference Macro
 

Select sheets b, c and d

EditFindOptionsWithinWorkbook

find what: sheeta

Find all

CTRL + a

Click on colorpicker icon and select a color.

All founds are now highlighted on sheets b, c and d


Gord Dibben MS Excel MVP

On Tue, 16 Jun 2009 06:24:01 -0700, Scott
wrote:

I know how to use the formula auditing tools, but was hoping for something
quicker than tracing through each one of them individually since there are
literally thousands of lines. I was hoping for a way to do it automatically.
Thanks!

"Jacob Skaria" wrote:

Try the below

2003: Menu ToolsFormula Auditing
2007: Menu FormulasFormula Auditing

Trace Precedents will show arrows to cells which are referenced in the
formula

Trace Dependents will show arrows to cells which are affected by the
selected cell

PS: In 2003 for regular use you may enable the formula auditing toolbar from
'Show Formula Auditing Tool Bar'

If this post helps click Yes
---------------
Jacob Skaria


"Scott" wrote:

I have a financial model with all of my inputs on tab A that populates
financial statements on tabs b, c, and d. Does anyone know of a way or have
a macro that would in some way highlight the cells on tabs b, c, and d that
are direct cell references to a line item on tab a. Thanks in advance for
your help!