Cell Reference Macro

[Scott]

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!

 

[Jacob Skaria]

Try the below

2003: Menu Tools>Formula Auditing>
2007: Menu Formulas>Formula 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

 

[Scott]

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!

 

[Gord Dibben]

Select sheets b, c and d

Edit>Find>Options>Within>Workbook

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