Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro - How to increment cell reference by one row | Excel Worksheet Functions | |||
absolute cell reference macro | Excel Discussion (Misc queries) | |||
Macro relative cell reference | Excel Worksheet Functions | |||
cell reference in macro | Excel Discussion (Misc queries) | |||
variable cell reference in a macro | Excel Discussion (Misc queries) |